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

165 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
kitsch153335(None) 
kirsch1532711kirsch
kitschy1941981kitschy
aitch105216162ait_ch
bitch125017762bit_ch
ditch115015092dit_ch
fitch134816872fit_ch
hitch134515472hit_ch
itch95619172_it_ch
ketch144912022ket_ch
kith115826352kit__h
kits86441762kits__
kitsches1734072kitsches
klatsch1651682klatsch
pitch125018412pit_ch
putsch1334932putsch
witch134517562wit_ch
aits46355533aits__
attach11118393attach
batch124620103bat_ch
biotech14104493biotech
birch124914023bi_rch
bitchy16479203bit_chy
bits66148153bits__
bitsy104511303bits_y
borsch1336133borsch
botch126717453bot_ch
butch125416543but_ch
catch125120373cat_ch
cinch124516243ci_nch
cisco95112133ci_sco
cutch125116193cut_ch
detach12310413detach
diptych1842613diptych
disc76123233di_sc_
disci85815023di_sci
disco85616073di_sco
discs85316263di_scs
dish86328333di_s_h
distich13312173distich
dits56450523dits__
ditsy95612563dits_y
dutch114713823dut_ch
etch95419143_et_ch
fetch134913473fet_ch
fetich1479693fetich
fiaschi1542793fiaschi
fiasco11104923fiasco
filch134813323fi_lch
finch135416973fi_nch
fisc96819753fi_sc_
fiscs105311883fi_scs
fish106926273fi_s_h
fitchy17437623fit_chy
fits76043463fits__
flitch14928173flit_ch
flysch1732893flysch
girsh95310023girs_h
gits55744593gits__
glitch12286353glit_ch
hatch135719593hat_ch
hits75545133hits__
hotch136214723hot_ch
hutch135414093hut_ch
ich86227743_i__ch
inch95420823_i_nch
itchy13449013_it_chy
its35538833_its__
kats85944333kats__
kench145513923k_ench
kiaugh1442813kiaugh
kibbeh17406063kibbeh
kiblah1535583kiblah
kibosh1534263kibosh
kick96026063ki__ck
kids96029633kids__
kifs116023503kifs__
kilts95122183kilts__
kimchi1743803ki_mchi
kins85747903kins__
kiosk836233kios_k
kiosks934383kiosks
kips106430513kips__
kirs85831733kirs__
kirsches1743843kirsches
kis78051473ki_s__
kiss85227393ki_s_s
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
kissy125510313ki_ssy
kist86540793ki_s_t
kists95822113ki_sts
kit78559873kit___
kitbag1334973kitbag
kitchen16287683kit_chen
kite85338233kit__e
kited105120093kit_ed
kiter95523213kit_er
kiters105218583kiters
kites95432543kit_es
kithe125917453kit_he
kithed144613013kithed
kithes135016653kithes
kiths125814973kit_hs
kiting114117093kiting
kitschify2451073kitschify
kitted115114833kitted
kittel10368863kittel
kitten104611483kitten
kittle104012173kittle
kitty124614563kit_ty
klatch15445933klatch
knish1238603knis_h
knits93914743knits__
kvetch1832993kvetch
latch104620463lat_ch
letch105215803let_ch
lich96230843li__ch
litchi1137893lit_chi
lits46252493lits__
match125621103mat_ch
matsah1138233matsah
mensch13387083mensch
milch124413373mi_lch
mitsvah1542163mitsvah
mutch125016173mut_ch
natch105018223nat_ch
nits45741643nits__
notch105613323not_ch
patch125221223pat_ch
pinch125619303pi_nch
pisco96314983pi_sco
pish96127913pi_s_h
pitchy16479673pit_chy
pith95432693pit__h
pits66348743pits__
pitsaw1135613pitsaw
quitch2036413quit_ch
ratch104221363rat_ch
retch104818303ret_ch
rich97025543ri__ch
rotch105815933rot_ch
sith75435153sit__h
sits45050203sits__
sketch1535353sket_ch
skits94721853skits__
snitch11357943snit_ch
stich104117923_stich
stitch11419103stitch
switch14458913swit_ch
tach96132753__tach
tech95925443__tech
tits46145033tits__
twitch14406163twit_ch
vetch134411843vet_ch
watch135617063wat_ch
wich125724743wi__ch
winch135016663wi_nch
wish107228733wi_s_h
witchy17468593wit_chy
with105730473wit__h
wits76044873wits__
zilch19438123zi_lch
zits136030293zits__

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.1261418182.5
2DLD Change Limit1127161656.34317770.1
3Display Results1651650.0463587.0
 (SQL Overall)1786911656.51527427.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.