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

107 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
unsicker143530(None) 
nicker123818702_n_icker
sicker124023902__sicker
snicker133012672sn_icker
unlicked15248262unlicked
unpacker16215892unpacker
unpicked17237212unpicked
unpucker16234272unpucker
anticked1538393anticked
bicker144819173__bicker
clicker154111883_clicker
deticker1545283deticker
dicker134521403__dicker
donnicker1643053donnicker
enricher1345003enricher
enticer91510423entic_er
flicker163610623_flicker
fossicker1843023fossicker
icker114018443___icker
indicter1148143indicter
insider849733insi_der
insister888783insister
kicker114116183__kicker
knacker12307913kn_acker
knickers13306723kn_ickers
knocker12296393kn_ocker
licker125222043__licker
mimicker1843313mimicker
monicker1635733monicker
musicked1734033musicked
necker124012793_n_ecker
nicer74618293_n_ic_er
nicked135019683_n_icked
nickel123811343_n_ickel
nickers134415093_n_ickers
picker144422173__picker
pricker154013413_pricker
quicker2247023_quicker
ransacker1543963ransacker
sacker125124843__sacker
shicker163914823_shicker
sicked134524403__sicked
sickee124622223__sickee
sicken124615253__sicken
siker95326033__si_ker
sinker103620903__sinker
slicker133314533_slicker
snacker133112603sn_acker
snicked143811633sn_icked
snickers143010963sn_ickers
snickery17295543sn_ickery
sticker133515883_sticker
sucker124120663__sucker
sunseeker1342503sunseeker
thicker163611023_thicker
ticker124321503__ticker
tricker134615523_tricker
unbacked17268733unbacked
unbitter1046173unbitter
uncocked17248753uncocked
undecked16238493undecked
undocked16277633undocked
unifier102211863un_ifier
uniquer1675783un_iquer
uniter64619143un_i_ter
unkinder1335363unkinder
unkinked12215903unkinked
unlike102614063unli_ke_
unliked122411283unli_ked
unlimber1243373unlimber
unlinked13237793unlinked
unlocked15268383unlocked
unluckier1541933unluckier
unmaker13279513un_maker
unmasker14245023unmasker
unmiter9310393unmi_ter
unpacked17268663unpacked
unpackers17203813unpackers
unpick1446903unpick__
unpicks1545183unpick_s
unpuckers17243123unpuckers
unriper9188283unri_per
unscrew1245463uns_crew
unshaken15175403unshaken
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unslaked1338463unslaked
unsliced1138093unslic_ed
unslick1356023unslick__
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unsober967643uns_ober
unsolder937213unsolder
unspoke1336573unspoke_
unspoken1454243unspoken
unstacked1636433unstacked
unstick1338123unstick__
unsticks1436233unstick_s
unstocked1645063unstocked
untacked15239923untacked
untidier946783untidier
untucked15206053untucked
unwinder1235613unwinder
unwiser1037123unwi_ser
whicker19359773_whicker
wicker154518673__wicker

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.436409841.7
2DLD Change Limit1461621077.26620115.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.74823062.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.