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

215 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
switched1715713(None) 
snitched14166861snitched
stitched14148201stitched
switcher16177681switcher
switches16159131switches
twitched17155031twitched
witched163012191_witched
bewitched2043232bewitched
bitched153212922_bitched
ditched143711902_ditched
flitched17256292flitched
hitched163312252_hitched
itched123812022__itched
pitched153512922_pitched
scotched16187932scotched
scutched16186892scutched
sketched1835392sketched
smirched1634672smirched
smutched16165922smutched
snatched14157632snatched
snitcher13157372snitcher
snitches13148982snitches
stitcher13168392stitcher
stitches131410592stitches
swatches16169962swatches
swathed144611932swat_hed
swished14418842swi_shed
switch14458912switch__
switchers17146632switchers
switchmen1962422switchmen
swithe124010682swit_he_
swither133710992swit_her
twitcher16135342twitcher
twitches16156372twitches
watched163012822_watched
winched163110592_winched
witches152715792_witches
withed134416232_wit_hed
aitches123014363_aitches
batched154114243_batched
bewitcher1943003bewitcher
bewitches1943823bewitches
birched15349913_birched
bitchen14349733_bitchen
bitches144117063_bitches
blotched1635653blotched
botched153611903_botched
britches15278683britches
cinched153910863_cinched
cliched153711023cli_ched
clinched16347383clinched
clutched16356033clutched
crotched16428593crotched
crutched16307463crutched
ditcher134012003_ditcher
ditches133215713_ditches
dowitcher1842593dowitcher
etched123613703__etched
faithed1437163fait_hed
fetched163710473_fetched
filched16307423_filched
fitchee152710783_fitchee
fitches153516193_fitches
fitchet153113563_fitchet
fitchew18276803_fitchew
fletched17306693fletched
flinched17316703flinched
flitches16388463flitches
glitches14296653glitches
grutched15284673grutched
hatched163414463_hatched
hitcher153712003_hitcher
hitches153616273_hitches
hotched163610923_hotched
hutched16359883_hutched
inched124514483__inched
itches114916213__itches
kitchen16287683_kitchen
kithed144613013_kit_hed
kvetched2142783kvetched
latched133914063_latched
letched133912053_letched
matched153513963_matched
miched143913393_mi_ched
niched125514063_ni_ched
notched134210303_notched
patched153514623_patched
pinched153812453_pinched
pitcher143813713_pitcher
pitches143617753_pitches
pithed124615613_pit_hed
quitches2236193quitches
restitched1644133restitched
retched133814273_retched
saithe94713913sait_he_
satchel123310303s_atchel
scathed134012643scat_hed
scooched16206683scooched
scootched1763963scootched
scorched16187193scorched
scotches15179473scotches
scratched1735393scratched
scutcher15176963scutcher
scutches15168883scutches
scythed16385303scyt_hed
searched14209253searched
seethed113410193seet_hed
seiche11811833sei_che_
seiches12513813sei_ches
shithead1535523shit_head
shitted114212053shit_ted
sicced11489653s_i_cced
sicked134524403s_i_cked
sighed113712053s_i_ghed
sited65130743s_it__ed
sketcher1735433sketcher
sketches1746823sketches
skited114313483skit__ed
slatches131511523slatches
sliced94416313sli_c_ed
slicked144413843sli_cked
slither104112983slit_her
slitted83513313slit_ted
slouched14206743slouched
smirches1535993smirches
smooched16185983smooched
smutches15177273smutches
snatcher13167763snatcher
snatches131410713snatches
snicked143811633sni_cked
snitch11357943snitch__
snitchers14166043snitchers
soothed113712743soot_hed
southed114313993sout_hed
spathed134013183spat_hed
spiced115218313spi_c_ed
spited94820443spit__ed
spitted103912703spit_ted
splotched1742823splotched
squinched2443083squinched
stanched14208903stanched
starched14199313starched
sticked144114633sti_cked
stitch11419103stitch__
stitchers14147013stitchers
stitchery17174073stitchery
stithied1235303stithied
stretched1546213stretched
suited74019423suit__ed
swacked173110523sw_acked
swashed144311363sw_ashed
swatch14549283swatch__
swathe125514113swat_he_
swather134213603swat_her
swathes134115513swat_hes
swatted114110693swat_ted
swigged13327183swi_gged
swilled113611833swi_lled
swindled13307623swindled
swineherd1682253swineherd
swinged123810793swi_nged
swingled13337433swingled
swinked15349033swi_nked
swiped123811093swi__ped
swirled11308223swi_rled
swisher13369523swi_sher
swishes133411373swi_shes
switcheroo1852063switcheroo
switching1835703switching
switchman1962203switchman
switchyard2251583switchyard
swith115917403swit_h__
swithered16135463swithered
swithers144310533swit_hers
swithly1634443swit_hly
swived133610633swi__ved
swiveled1544163swiveled
swizzled2053013swizzled
swooshed15174273swooshed
swotted11398713swot_ted
synched16277213s_ynched
tetched133010773_tetched
thatched1735433thatched
tithed104115593_tit_hed
twitch14406163twitch__
twitchers17134533twitchers
twitchier1753233twitchier
twitchy18393573twitch_y
twitted11326633twit_ted
unhitched1843093unhitched
unstitched1643513unstitched
unwatched1844083unwatched
watcher153113403_watcher
watches153017373_watches
welched16298833_welched
wenched163910913_wenched
wiches144418753_wi_ches
wicked164317413_wi_cked
winced124415343_winc_ed
wincher153410653_wincher
winches154714373_winches
wished134417513_wi_shed
witch134517563_witch__
witchery19236093_witchery
witchier16307883_witchier
witchweed2142773_witchweed
witchy17468593_witch_y
wited94727143_wit__ed
withe115220233_wit_he_
wither124321353_wit_her
withes124620843_wit_hes
withheld1842353_withheld
witted104216813_wit_ted
wretched17276533wretched
writhed14389623writ_hed

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 Limit1461622157.36019859.0
3Display Results2152150.0762828.9
 (SQL Overall)1786912157.85922737.1
 
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.