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 “uncuff” 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
uncuff143611(None) 
uncuffs1543141uncuffs
cuff125327992__cuff
scuff133914892_scuff
snuff113514042sn_uff
uncuffed1734082uncuffed
uncurb1037042uncurb
uncurl839412uncurl
uncus74014982uncu_s
uncut73219172uncu_t
uncute82912132uncute
bluff134413833_bluff
buff125229863__buff
caff125631673__caff
chuff164812493_chuff
coff126930783__coff
cuffs135017493__cuffs
cuif96529143__cuif
curf97538783__curf
duff114326643__duff
engulf1038883engulf
enuf7323843en_u_f
fluff103913613_fluff
gruff124712143_gruff
guff114624933__guff
handcuff2042553handcuff
huff135623843__huff
incubi1035113incubi
incult82414773incult
incur72212253incu_r
incurs83012283incurs
incus73315053incu_s
incuse83513573incuse
ingulf10310353ingulf
luff104426703__luff
muff124723863__muff
naff105128933_n_aff
pouff135215423_pouff
puff125525433__puff
rebuff1437023rebuff
ruff105127653__ruff
runoff1235413run_off
scoff134413343_scoff
scruff1437963scruff
scuffs14419053_scuffs
scurf104719323_scurf
sluff114016813_sluff
sniff113915863sn_iff
snuffs12358533sn_uffs
snuffy15356243sn_uffy
stuff113817053_stuff
tuff104528523__tuff
unau43924153unau__
unaus53216573unau_s
unbusy1135213unbusy
uncage93014873uncage
uncake122813523uncake
uncap9312283unc_ap
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unchic1338643unchic
unci65019463unc__i
uncia75015163unc_ia
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
unclad938913unclad
uncle7317053unc_le
uncleft1257493uncleft
uncles8317163uncles
unclip1046993unclip
unclog956603unclog
unco66021403unc__o
uncock1438563uncock
uncoffin1643083uncoffin
uncoil8811853uncoil
uncool8610113uncool
uncork1239043uncork
uncos74117033unc_os
uncouth1247173uncouth
uncoy104111413unc_oy
uncuffing1843703uncuffing
uncurbs1134913uncurbs
uncured10513233uncured
uncurls937123uncurls
undue66715553undu_e
unduly1037823unduly
unfurl937953unfurl
ungual738183ungual
ungues7412123ungues
unguis738453unguis
ungula737603ungula
unhung1035283unhung
unhurt9311253unhurt
unhusk1334263unhusk
unify113611113un_ify
unjust1337873unjust
unmuffle1662343unmuffle
unpure82911533unpure
unroof9410193unroof
unruly938083unruly
unsafe9310693unsafe
unstuffy1761673unstuffy
unsung736983unsung
unsunk1036333unsunk
unsure62815413unsure
untuck1236403untuck
untune62511603untune
upcurl1034963upcurl

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161105.42320784.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911105.60931857.9
 
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.