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 “fussilz” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
fussily13267601fussily
fissile10269652fissile
fossil9379352fossil_
fossils10379012fossils
fusil84715322fu_sil_
fusile94313492fu_sile
fusils93912342fu_sils
fussier103610672fussier
fussing113611682fussing
fustily133111372fustily
mussily12279772mussily
bossily1237563bossily
bushily15268893bushily
busily112211503bu_sily
bussing103614623bussing
cushily15257923cushily
cussing103814273cussing
dossil75110903dossil_
dossils8669773dossils
duskily15236743duskily
dustily113211523dustily
fessing113812863fessing
fishily1637643fishily
fission1038733fission
flossily1434523flossily
fossick16134733fossick
fossilize2143853fossilize
fubsier12367763fubsier
fuggily1534963fuggily
fulfil1246423fulfil_
fulfill1345023fulfill
fulfils1345723fulfils
funkily1736513funkily
funnily1336373funnily
furrily1337613furrily
fusain958643fusai_n
fusains1038363fusains
fusel85218493fu_sel_
fusels94412453fu_sels
fusible1237023fusible
fusibly1535863fusibly
fusilli1044233fusilli
fusing104415953fu_sing
fusion939773fu_sion
fuss76027933fuss___
fussed104613803fuss_ed
fusser94813773fuss_er
fussers104210813fussers
fusses94920553fuss_es
fussiest112910493fussiest
fusspot1244073fusspot
fussy115613953fuss__y
fustian1036903fustian
fustic11910633fusti_c
fustics1279593fustics
fustier104213933fustier
futile93914953fu_tile
fuzil173810703fu_zil_
fuzils18407963fu_zils
fuzzily2145073fuzzily
gassily1137813gassily
gushily14257823gushily
gussie72910153gussi_e
gussied9267193gussied
gussies82813303gussies
gustily113010903gustily
gutsily11267223gutsily
huskily17236333huskily
hussies103213293hussies
jussive1734293jussive
lustily103611243lustily
messily12298813messily
missile92815403missile
mudsill1045163mudsill
mushily152410093mushily
muskily16289043muskily
mussel83412903mussel_
mussels9419843mussels
mussier93314363mussier
mussing104015543mussing
mustily123613633mustily
pursily1238213pursily
pushily15247983pushily
pussier93711993pussier
pussies93615693pussies
pussly11407373puss_ly
russify1334063russify
rustily103112993rustily
sassily1038723sassily
sessile739523sessile
sussing84013703sussing
tussal6288323tussal_
tussis6379953tussi_s
tussive1035303tussive
tussle637143tuss_le
unfussily1541883unfussily
wussier10408083wussier
wussies103411083wussies

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027985.67323625.4
3Display Results98980.0303266.7
 (SQL Overall)178691986.10929250.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.