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

133 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
zaddik213424(None) 
tzaddik2241761tzaddik
zaddick2442991zaddick
baddie104114032baddie
caddie104316452caddie
caddis104613382caddis
gaddi85211632gaddi_
gaddis94211372gaddis
laddie83713172laddie
tsaddik1342072tsaddik
waddie114013322waddie
zaddikim2551422zaddikim
add510132373_add__
addax1435993_addax
added84918433_added
adder75419593_adder
addict10711203_addict
adding93914963_adding
addle74318353_addle
adds67622463_add_s
adit56443663_a_dit
admit8319493_admit
admix1557733_admix
asdic83814093_asdic
audio62917103_audio
audit62527883_audit
badder103817513badder
baddies114017873baddies
baddy125016023badd_y
bandit93821133bandit
bardic11312923bardic
batik11614733ba_tik
battik1238093battik
caddice13327733caddice
caddied123710563caddied
caddies113718383caddies
caddish143810133caddish
caddy125414023cadd_y
cadi75732193ca_di_
cadis84428503ca_dis
cadmic1338983cadmic
candid104517853candid
cardia9916383cardia
cardio9915673cardio
cuddie104011173cuddie
daddies103414943daddies
daddle94214283daddle
daddy116212563dadd_y
dikdik1152613dikdik
duddie9348863duddie
faddier1237783faddier
faddish15359003faddish
faddism14356723faddism
faddist12289643faddist
faddy135511623fadd_y
fadein1068843fadein
fadlike15318483fadlike
gadded103913173gadded
gadder93714713gadder
gadding113411453gadding
gadi66329733ga_di_
gadid85517383ga_did
gadids95611823gadids
gadis74825293ga_dis
gadoid9310463gadoid
haddock1885583haddock
hadji16839893hadji_
hadjis17439653hadjis
haik115526983ha__ik
hoddin11369943hoddin
kaddish16317973kaddish
kadi96224843ka_di_
kadis105921073ka_dis
kamik105011563ka_mik
kiddie12359403kiddie
ladder84617623ladder
laddies93715053laddies
laddish12299723laddish
madded113513553madded
madden103912523madden
madder103515593madder
madding123711993madding
maddish14289483maddish
nadir61012973na_dir
nandin7313033nandin
nudnik1153313nudnik
padauk1335643padauk
padded114113503padded
padder103415493padder
paddies113715723paddies
padding123412513padding
paddle104615143paddle
paddock17104733paddock
paddy125913593padd_y
padi76331793pa_di_
padis86227143pa_dis
padouk1336683padouk
padri85815173padri_
paik105726803pa__ik
pandit93820753pandit
pardi85723953pardi_
pardie96021443pardie
qadi145621113qa_di_
qadis155917853qa_dis
radded94716493radded
radding103715003radding
raddle84816173raddle
radii64016413ra_dii
radio64922493ra_dio
radix134414603ra_dix
sadden83212403sadden
sadder82916973sadder
saddhu1133413saddhu
saddle83915493saddle
sadi55834653sa_di_
sadis64930853sa_dis
tzaddikim265693tzaddikim
wadded124014173wadded
wadder114215483wadder
waddied13358563waddied
waddies124214753waddies
wadding133711943wadding
waddle114715303waddle
waddly14478723waddly
waddy135312993wadd_y
wadi86228183wa_di_
wadis95223963wa_dis
widdie113410733widdie
zaffir21395513zaffir
zaftig1933253zaftig
zamia165115213za_mia
zander163417113zander
zayin174512043za_yin

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161336.42317548.8
3Display Results1331330.0931430.1
 (SQL Overall)1786911336.88925938.6
 
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.