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

264 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
switches1615913(None) 
snitches13148981snitches
stitches131410591stitches
swatches16169961swatches
switched17157131switched
switcher16177681switcher
switchers17146631switchers
twitches16156371twitches
witches152715791_witches
aitches123014362_aitches
bewitches1943822bewitches
bitches144117062_bitches
britches15278682britches
ditches133215712_ditches
fitches153516192_fitches
flitches16388462flitches
glitches14296652glitches
hitches153616272_hitches
itches114916212__itches
pitches143617752_pitches
quitches2236192quitches
scotches15179472scotches
scutches15168882scutches
seiches12513812sei_ches
sketches1746822sketches
slatches131511522slatches
smirches1535992smirches
smutches15177272smutches
snatches131410712snatches
snitched14166862snitched
snitcher13157372snitcher
snitchers14166042snitchers
stitched14148202stitched
stitcher13168382stitcher
stitchers14146992stitchers
swathes134115512swat_hes
swishes133411372swi_shes
switch14458912switch__
switchmen1962422switchmen
swithe124010682swit_he_
swither133710992swit_her
swithers144310532swit_hers
twitched17155032twitched
twitcher16135342twitcher
twitchers17134532twitchers
watches153017372_watches
wiches144418752_wi_ches
winches154714372_winches
witched163012192_witched
withes124620842_wit_hes
batches144019613_batches
bewitched2043233bewitched
bewitcher1943003bewitcher
bewitchers2042563bewitchers
birches143412323_birches
bitched153212923_bitched
bitchen14349733_bitchen
blotches1537433blotches
botches143716023_botches
brioches15227253brioches
butches144315363_butches
catches144320763_catches
chinches18369363chinches
cinches144215773_cinches
cliches144213743cli_ches
clinches153910363clinches
clutches15307913clutches
cratches153012543cratches
crotches153411293crotches
crutches15359583crutches
cultches15316533cultches
cutches143216453_cutches
ditched143711903_ditched
ditcher134012003_ditcher
ditchers143610363_ditchers
dowitcher1842593dowitcher
dowitchers1942133dowitchers
etches114217763__etches
fetches153413893_fetches
fetiches1636953fetiches
fiches145219533_fi_ches
filches153410723_filches
finches153914193_finches
fitchee152710783_fitchee
fitchet153113563_fitchet
fitchets16307413_fitchets
fitchew18276803_fitchew
fitchews19274773_fitchews
fletches16308853fletches
flinches16358953flinches
flitched17256293flitched
grinches1436943grinches
grutches14285853grutches
hatches153420273_hatches
hitched163312253_hitched
hitcher153712003_hitcher
hitchers16379993_hitchers
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inches114419673__inches
itched123812023__itched
ketches164012193_ketches
kitchen16287683_kitchen
kitchens17195783_kitchens
kithes135016653_kit_hes
kitsches1734073_kitsches
klatches17157133klatches
kvetches2053583kvetches
latches123320123_latches
letches124015483_letches
liches114724293_li_ches
litchis1238373_litchis
matches143219783_matches
miches134320733_mi_ches
mutches143314283_mutches
nautches1336073nautches
niches114419143_ni_ches
nitchies1339073_nitchies
notches123513653_notches
painches1588913painches
patches143320383_patches
pinches144117933_pinches
pitched153512923_pitched
pitcher143813713_pitcher
pitchers153211483_pitchers
potiches1539203potiches
quiches2139333qui_ches
ratches123620463_ratches
restitches1545063restitches
retches123318513_retches
riches115022083_ri_ches
rotches123515703_rotches
saices84221803sai_c_es
saithe94713913sait_he_
satchel123310303s_atchel
satchels13328163s_atchels
scathes124515713scat_hes
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scratches1647313scratches
sculches15176273sculches
scultches1664293scultches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
scythes15356523scyt_hes
searches132112903searches
seethes103613743seet_hes
seiche11811833sei_che_
seviches1635803seviches
shitakes1546113shitakes
sices75637273s_i_c_es
sitcoms1145533s_itcoms
sites56045433s_it__es
sithens1039383s_it_hens
situses72710493s_ituses
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
skites104418033skit__es
skittles1245763skittles
slices84022853sli_c_es
slither104112983slit_her
slithers114212953slit_hers
slouches13208073slouches
smirched1634673smirched
smites83921923smit__es
smithers13369793smit_hers
smithies1337913smithies
smiths114711023smit_h_s
smooches15217263smooches
smutched16165923smutched
snatched14157633snatched
snatcher13167753snatcher
snatchers14146303snatchers
snathes104816493snat_hes
snitch11357943snitch__
soothes103917103soot_hes
soroches1338803soroches
soutaches1446443soutaches
spathes125116533spat_hes
speeches1537413speeches
spices104326033spi_c_es
spinaches1645273spinaches
spites84127333spit__es
spittles1038333spittles
spitzes1849173spit_zes
splotches1643913splotches
squinches2344253squinches
staithes1138953stait_hes
stanches132312793stanches
starches131912913starches
stenches132110293stenches
stichs114511653sti_ch_s
stitch11419103stitch__
stitchery17174063stitchery
stithies1139233stithies
stretches1438283stretches
suitcase1043893suitcase
suitcases1144453suitcases
suites63727403suit__es
swashes134714403sw_ashes
swatch14549283swatch__
swathe125514113swat_he_
swathed144611933swat_hed
swather134213593swat_her
swathers144512073swat_hers
swaths125312643swat_h_s
swindles12319503swindles
swinges113413423swi_nges
swingles12319543swingles
swipes114114333swi__pes
swiples12339643swi_ples
swipples1534843swipples
swished14418843swi_shed
swisher13369523swi_sher
swishers14328053swi_shers
swisses10417143swi_sses
switcheroo1852063switcheroo
switcheroos1951923switcheroos
switching1835703switching
switchman1962203switchman
swith115917403swit_h__
swithly1634443swit_hly
swives123915183swi__ves
swizzles1953783swizzles
swooshes14185123swooshes
thatches1637513thatches
tithes94720213_tit_hes
twitch14406163twitch__
twitchier1753233twitchier
twitchiest1842963twitchiest
twitchy18393573twitch_y
unhitches1743073unhitches
unstitches1543563unstitches
vetches153411263_vetches
watched163012823_watched
watcher153113403_watcher
watchers163511793_watchers
welches153710313_welches
wenches152914133_wenches
winces114819113_winc_es
winched163110593_winched
wincher153410653_wincher
winchers16319223_winchers
wishes124920953_wi_shes
witch134517563_witch__
witchery19236093_witchery
witchier16307883_witchier
witchiest1736313_witchiest
witchy17468593_witch_y
wites85536963_wit__es
withe115220233_wit_he_
withed134416233_wit_hed
wither124321353_wit_her
withers134417753_wit_hers
withies133913543_withies
wretches16257283wretches
writhes134811703writ_hes
wyches17387913_w_yches
zilches21326303_zilches

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.1731032896.0
2DLD Change Limit1461622647.17020385.2
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.45323975.7
 
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.