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 “fusilier” 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.

120 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
fusilier113542(None) 
fusileer1143261fusileer
fusiliers1243711fusiliers
fusile94313492fusil_e_
fusileers1242722fusileers
fussier103610672fus_sier
fustier104213932fus_tier
auntlier834903auntlier
basifier1337313basifier
bubblier1184473bubblier
builder1037573bu_ilder
bullier94116433bu_llier
burblier1255603burblier
burlier93514413bu_rlier
bushier123712813bus_hier
busier85219723bus__ier
bustier93916153bus_tier
bustler94012563bustl_er
costlier1038523costlier
cuddlier1234013cuddlier
curlier93314183cu_rlier
cushier123610833cus_hier
desilver12286503desilver
duskier12409433dus_kier
dustier83814133dus_tier
falsifier1544433falsifier
familiar1365953familiar
families1339443families
featlier1136453featlier
feistier1136193feistier
filer85433003f__il_er
filler94623623f__iller
filmer114112403f__ilmer
filmier1237503f__ilmier
filter94517633f__ilter
fishier13359853fis_hier
fleshlier1542493fleshlier
flier86023403f___lier
frailer10319943frail_er
friller104111743f_riller
frillier1136513frillier
friskier1535193friskier
fruitier1136593fruitier
fubsier12367763fu_bsier
fueler94313933fu_el_er
fueller10279963fu_eller
fuggier12348963fu_ggier
fulfiller1542783fulfiller
fuller94220383fu__ller
fumbler143610813fumbl_er
fumier11310903fu__mier
funkier14349983fu_nkier
funnier103210173fu_nnier
furler93616403fu_rl_er
furrier103513663fu_rrier
furzier19318103fu_rzier
fuselike1535673fuselike
fusible1237023fusible_
fusil84715323fusil___
fusilli1044233fusil_li
fusillis1143563fusillis
fusils93912343fusil__s
fusser94813773fus__ser
futile93914953futil_e_
futility1446973futility
fuzzier18256523fu_zzier
gasalier936443gasalier
gaselier946963gaselier
gasifier1236273gasifier
gasolier935833gasolier
grislier935793grislier
guilder945913gu_ilder
guiltier934493gu_iltier
gushier113110073gus_hier
gustier83813863gus_tier
huskier14369763hus_kier
hustler103410753hustl_er
juicier1635463ju_icier
junglier1644303junglier
justifier1944363justifier
lustier73813503lus_tier
mushier123813593mus_hier
muskier134312733mus_kier
mussier93314363mus_sier
mustier94017963mus_tier
nubblier1254413nubblier
oilier64417233__oilier
ossifier111196273ossifier
outlier72216143ou_tlier
puddlier1234213puddlier
purifier1338573purifier
pushier123611093pus_hier
pussier93711993pus_sier
pusslies1036173pusslies
quilter16279803qu_ilter
resilver11337503resilver
roilier7311523_roilier
rubblier1244913rubblier
rufflier1434013rufflier
rulier65016353ru__lier
rumplier1235303rumplier
rushier103411973rus_hier
rustier74416363rus_tier
rustler73512343rustl_er
silkier114411643__silkier
siller64026063__siller
sillier74017593__sillier
siltier73413863__siltier
silver93815813__silver
sizier1514813393__sizier
slier54827243__s_lier
supplier1246603supplier
surlier72915443su_rlier
uglier748953_u_glier
unifier102211863_unifier
utiliser855243_utiliser
utilizer1756203_utilizer
wilier93217073__wilier
wiselier1137363wiselier
wussier10408083wus_sier

Search took 9 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.470380193.6
2DLD Change Limit1461621207.53319402.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.04922200.4
 
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.