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

110 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
nonskier123598(None) 
nonskiers1345011nonskiers
boskier13309172bo_skier
noisier759452nois_ier
nonskater1345142nonskater
nonsked1236232nonsk_ed
nonskid1246382nonski_d
nosier63716322no_s_ier
sonsier7711742sons_ier
wonkier1437422won_kier
bonier84321993bon__ier
bonnier94711313bon_nier
bonspiel1243543bonspiel
bosker123813653bo_sk_er
bossier93712423bo_ssier
cockier154013623co_ckier
conker124721553con_k_er
consider11310393consider
consoler102812613consoler
conspire1257873conspire
conspirer1355293conspirer
consumer1238503consumer
corkier133114303co_rkier
cosier84423753co_s_ier
dinkier123411503din_kier
donniker1333923donniker
donsie7613643dons_ie_
dorkier122810023do_rkier
dossier83711693do_ssier
duskier12409433_duskier
enskied1234653_enskied
enskies1138573_enskies
folkier14359043fo_lkier
folksier1533533folksier
forkier144311593fo_rkier
friskier1535193friskier
funkier14349983fun_kier
goosier83512563goos_ier
gorsier83811073gors_ier
gunkier12369553gun_kier
hinkier143610793hin_kier
hokier134214033ho__kier
honker134117463hon_k_er
honkie133011673hon_kie_
honkies143015143hon_kies
hookier143811673ho_okier
horsier103013243hors_ier
hosier94219613ho_s_ier
hunkier144512143hun_kier
huskier14369763_huskier
inkier104013783_in_kier
jokier17618753jo__kier
junkier18339493jun_kier
kinkier10319433kin_kier
kookier10398283ko_okier
lankier113711633lan_kier
lonelier838003lonelier
lousier72411623lous_ier
moniker1338673monik_er
monsieur1043313mons_ieur
monster93214603mons_ter
mossier94413813mo_ssier
mousier93712463mous_ier
muskier134312733_muskier
nastier74115293n_astier
newsier10147223news_ier
nobbier11309163no_bbier
nondriver1344863nondriver
nonjoiner1665333nonjoiner
nonowner1145253nonowner
nonsigner1045363nonsigner
nonskaters1444483nonskaters
nonskeds1343933nonskeds
nonslip946553nonsli_p
nonsmoker1544303nonsmoker
nonsolar847083nonsolar
nonstick1447593nonstick
nonsugar944363nonsugar
nonsuit7811343nonsui_t
nonsuited1046573nonsuited
nonsuits869153nonsuits
nonswimmer1751473nonswimmer
nonuser7299143non_user
nonvoter1186893nonvoter
nonwriter1246223nonwriter
nookie103712433no_okie_
nookies113414963no_okies
nooser65517823noos__er
nosher94616363no_s_her
notifier1137423notifier
nutsier7329253nuts_ier
oakier104011393_o_akier
onerier7311613_onerier
osier53518013_o_s_ier
peskier13319113_peskier
pockier153911603po_ckier
pokier124914633po__kier
porkier133712343po_rkier
punkier133512793pun_kier
riskier1138423_riskier
rockier134911883ro_ckier
rookier114012383ro_okier
rosier64221263ro_s_ier
skier95119593___skier
snakier112810003_snakier
sonsie6614863sons_ie_
toastier846893toastier
tonier65520713ton__ier
yolkier14336123yo_lkier
yonker134110853yon_k_er

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.423422437.4
2DLD Change Limit1461621108.08018089.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.54920902.0
 
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.