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

147 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
kvetches205358(None) 
ketches164012191k_etches
kvetched2142781kvetched
kvetcher2052811kvetcher
kvetchers2142371kvetchers
vetches153411261_vetches
etches114217762__etches
fetches153413892_fetches
fletches16308852fletches
kenches163912272k_enches
klatches17157142klatches
kvetch1832992kvetch__
kvetchier2141862kvetchier
kvetchiest2241952kvetchiest
kvetchy2241802kvetch_y
letches124015482_letches
retches123318512_retches
sketches1746822sketches
wretches16257282wretches
aitches123014363_aitches
avouches1634823avouches
batches144019613_batches
beaches144120653_beaches
beeches143413883_beeches
belches143514343_belches
benches143918603_benches
bitches144117063_bitches
bleaches153410673bleaches
blenches153310763blenches
blotches1537433blotches
botches143716023_botches
breaches153714123breaches
breeches15258673breeches
britches15278683britches
butches144315363_butches
catches144320773_catches
ceviches1834843ceviches
clenches152910953clenches
clutches15307923clutches
cratches153012543cratches
creches14313093cre_ches
crotches153411303crotches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
detaches1439653_detaches
ditches133215713_ditches
drenches14309803drenches
eches106322163__e_ches
etched123613703__etched
etcher113912943__etcher
etchers123411293__etchers
fetched163710473_fetched
fetcher153510393_fetcher
fetchers16328863_fetchers
fetiches1636953_fetiches
fitches153516193_fitches
fleches153411443fle_ches
fleeches16287083fleeches
flenches163410533flenches
fletched17306693fletched
fletcher16306663fletcher
fletchers17335533fletchers
flitches16388463flitches
frenches163311633frenches
glitches14296663glitches
grutches14285853grutches
hatches153420273_hatches
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
itches114916213__itches
ketch144912023k_etch__
ketchup1842783k_etchup
ketchups1941893k_etchups
ketenes114813503k_etenes
ketones115014503k_etones
ketoses114912873k_etoses
kettles113411613k_ettles
kheths16495973khet_h_s
kirsches1743843kirsches
kitchen16287683k_itchen
kitchens17195783k_itchens
kithes135016653k_it_hes
kitsches1734073kitsches
klatsches1842233klatsches
kvetching2242903kvetching
kythes16499133k_yt_hes
latches123320133_latches
leaches123319343_leaches
leches115421313_le_ches
leeches123911933_leeches
letched133912053_letched
lethes94818083_let_hes
matches143219783_matches
merches144013763_merches
mutches143314283_mutches
nautches1336083nautches
notches123513653_notches
patches143320383_patches
peaches144120053_peaches
perches143717953_perches
pitches143617753_pitches
pleaches153210433pleaches
plenches153110623plenches
preaches153214893preaches
quenches2236013quenches
quitches2236193quitches
ratches123620463_ratches
reaches123423203_reaches
retched133814273_retched
rotches123515703_rotches
scotches15179473scotches
scutches15168883scutches
seethes103613743seet_hes
seiches12513813_seiches
seviches1635803seviches
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slatches131511533slatches
smutches15177273smutches
snatches131410713snatches
snitches13148983snitches
speeches1537413speeches
stenches132110293stenches
stitches131410593stitches
stretches1438293stretches
swatches16169963swatches
switches16159133switches
teaches122718353_teaches
teethes103611653teet_hes
tenches123515523_tenches
tetched133010773_tetched
thatches1637513thatches
trenches133512603trenches
twitches16156373twitches
vetch134411843_vetch__
vetoes92914083_vet_oes
vouches153914113_vouches
watches153017373_watches
welches153710313_welches
wenches152914133_wenches
witches152715793_witches
wrenches163210233wrenches
wretched17276533wretched

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.423422437.4
2DLD Change Limit1461621476.67321903.5
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.15624970.8
 
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.