Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “filliped” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
filliped143522(None) 
milliped1337381milliped
filled104922262fill__ed
filleted1236602filleted
fillies103420252filli_es
fillip11268952fillip__
fillips12298132fillip_s
fissiped1444152fissiped
gillied95512312gilli_ed
milleped1335172milleped
millipede1444222millipede
millipeds1444702millipeds
willied114611562willi_ed
aliped95414283__aliped
allied74217153_alli_ed
bellied104314073belli_ed
billed94224903bill__ed
billeted1137643billeted
billiard1145873billiard
billie85019173billi_e_
billies93923503billi_es
billowed14137063billowed
bollixed1834483bollixed
bullied104514813bulli_ed
callipee1237733callipee
calliper1247513calliper
cheliped1635043cheliped
cirriped1344183cirriped
collided12309803collided
collied103316673colli_ed
cullied104012353culli_ed
dallied93713613dalli_ed
dilled84122223dill__ed
dillies84122163dilli_es
disliked14288553disliked
dollied93811143dolli_ed
dolloped1234983dolloped
fallowed15127753fallowed
fellated1239563fellated
felled103720303fell__ed
fellies104119743felli_es
fellowed15136833fellowed
fielded12206813fiel_ded
filched16307423fi_lched
filed95331903fi_l__ed
fileted1159093fi_leted
filiated12610083filiated
filibeg1353383fi_libeg
fille84327403fill__e_
filler94623623fill__er
filles94224523fill__es
fillet95027083fill__et
filling113520803filli_ng
fillings122910503fillings
filliping1544233filliping
fillister1244423fillister
filmed124610363fi_l_med
filmier1237503filmi_er
filmlike1734443filmlike_
filtered12259043filtered
finalised13338013finalised
finalized22279243finalized
finlike14279063finlike_
fissipeds1542423fissipeds
flailed1137303f_lailed
flapped15328253f_lapped
flied96519433f__li_ed
flipped15358513f_lipped
flited104616583f__lited
flopped15338763f_lopped
flumped15377713f_lumped
folioed1138033f_olioed
follies103618943folli_es
followed15146273followed
frilled113911603frill__ed
frillier1136513frilli_er
fulled103820653full__ed
fullered1236383fullered
fulmined1454333fulmined
gallied94115003galli_ed
galloped12107153galloped
gilled84521633gill__ed
gillie74816943gilli_e_
gillies84120963gilli_es
gullied93812063gulli_ed
hilled104022223hill__ed
hillier103413963hilli_er
hilloaed12136923hilloaed
hilloed113211293hill_oed
illite63414923_illite_
illites72415013_illites
illuded9305763_illuded
illumed10285863_illumed
jellied15419223jelli_ed
jollied15349273jolli_ed
killed113918773kill__ed
killie104114893killi_e_
killies113318113killi_es
lilied73913213li_li_ed
lilliput1044193lilliput
lolloped1134463lolloped
maxilliped2251553maxilliped
milled94326173mill__ed
millepede1442983millepede
millepeds1443223millepeds
milliard1147033milliard
millier93716703milli_er
millime112511403millime_
millimes122411373millimes
milline92519113milline_
milliner102811863milliner
millines102718063millines
millipedes1543713millipedes
millirem1245693millirem
misliked15319513misliked
mislived14328783mislived
multiped1337373multiped
nilled73919453nill__ed
pillaged12298093pillaged
pillared11228093pillared
pilled94222753pill__ed
pillowed14156383pillowed
pinniped1343853pinniped
rallied83514083ralli_ed
rilled74525653rill__ed
sallied83316953salli_ed
sillier74017593silli_er
sillies73425083silli_es
sliped95417063__sliped
sullied83714483sulli_ed
taliped1078203_taliped
tallied83314753talli_ed
tilled74722953till__ed
tillered937443tillered
tillite7313563tillite_
tillites8312833tillites
vilipend1442523vi_lipend
walloped14146833walloped
willed104722453will__ed
willie94116453willi_e_
willies103920153willi_es
willowed15156763willowed

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit1461621426.70621795.7
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.