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

134 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
twitchers1713453(None) 
switchers17146631switchers
twitcher16135341twitcher_
twitches16156371twitche_s
bewitchers2042562bewitchers
ditchers143610362_ditchers
dowitchers1942132dowitchers
hitchers16379992_hitchers
pitchers153211482_pitchers
snitchers14166042snitchers
stitchers14147012stitchers
switcher16177682switcher_
switches16159132switche_s
swithers144310532swit_hers
thatchers1744582thatchers
tithers104216732t_it_hers
twitched17155032twitche_d
twitchier1753232twitchier_
twitters11296772twit_ters
watchers163511792_watchers
winchers16319222_winchers
witchery19236092_witchery
witches152715792_witche_s
withers134417752_wit_hers
aitches123014363_aitche_s
batchers153613273_batchers
bewitcher1943003bewitcher_
bewitchery2351663bewitchery
bewitches1943823bewitche_s
bitchery18236563_bitchery
bitches144117063_bitche_s
blithers134711233blit_hers
botchers153511543_botchers
britches15278683britche_s
butchers153710183_butchers
catchers153114063_catchers
cithers124315773_cit_hers
clinchers16336263clinchers
ditcher134012003_ditcher_
ditches133215713_ditche_s
dithers114016153_dit_hers
dowitcher1842593dowitcher_
etchers123411293__etchers
fetchers16328863_fetchers
filchers16286863_filchers
fitches153516193_fitche_s
fitchets16307413_fitchets
fitchews19274773_fitchews
fletchers17335533fletchers
flinchers17295473flinchers
flitches16388463flitche_s
glitches14296663glitche_s
hatchers163113173_hatchers
hitcher153712003_hitcher_
hitches153616273_hitche_s
inchers123912523__inchers
itches114916213__itche_s
kitchens17195783_kitchens
kvetchers2142373kvetchers
matchers153012433_matchers
mithers123516733_mit_hers
notchers13279423_notchers
patchers153413303_patchers
pinchers153510613_pinchers
pitcher143813713_pitcher_
pitches143617753_pitche_s
quitches2236193quitche_s
scutchers16175643scutchers
sketchers1834513sketchers
slithers114212953slit_hers
smithers13369793smit_hers
snatchers14146313snatchers
snitcher13157373snitcher_
snitches13148983snitche_s
stitcher13168393stitcher_
stitchery17174073stitchery
stitches131410593stitche_s
stretchers1545173stretchers
swatches16169963swatche_s
swathers144512083swat_hers
swishers14328053swi_shers
switched17157133switche_d
switcheroo1852063switcheroo
switcheroos1951923switcheroos
swither133710993swit_her_
teachers133212393t_eachers
teethers11328713teet_hers
tethers103815313t_et_hers
thatcher1635663thatcher_
thatches1637513thatche_s
thither13328103thit_her_
tickers133617723t_i_ckers
titers64526413t_it__ers
titfers10318933t_it_fers
tither94920283t_it_her_
tithes94720213t_it_he_s
titters74219623t_it_ters
tochers123413093t__ochers
touchers133611213t_ouchers
trenchers14288073trenchers
trickers143812813tri_ckers
twiddlers14313693twiddlers
twiers95410163twi___ers
twiners10459633twi__ners
twinklers1633063twinklers
twirlers11274303twi_rlers
twisters11268173twi_sters
twitch14406163twitch___
twitchiest1842963twitchiest
twitchily2052193twitchily
twitching1834243twitching
twitchy18393573twitch__y
twitter10278093twit_ter_
twitterers1342673twitterers
twittery14303893twit_tery
watcher153113403_watcher_
watches153017373_watche_s
welchers16338053_welchers
wenchers16319213_wenchers
wethers135214693_wet_hers
wiches144418753_wi_che_s
wickers164114703_wi_ckers
wincers123415363_winc_ers
wincher153410653_wincher_
winches154714373_winche_s
wishers133215213_wi_shers
witched163012193_witche_d
witcheries1845463_witcheries
witchier16307883_witchier_
wither124321353_wit_her_
withes124620843_wit_he_s
writhers14398983writ_hers
wuthers133711523_wut_hers
zithers193911973_zit_hers

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411346.03024650.2
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.49927495.2
 
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.