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

192 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
fletched1730669(None) 
fetched163710471f_etched
fleeched17345821fleeched
flenched17267961flenched
fletcher16306661fletcher
fletches16308851fletches
flitched17256291flitched
letched133912051_letched
bleached16378562bleached
blenched16358052blenched
blotched1635652blotched
clenched16257762clenched
clutched16356032clutched
etched123613702__etched
fetcher153510392f_etcher
fetches153413892f_etches
fleche14299302fle_che_
fleches153411442fle_ches
flecked17358072fle_cked
fleeced13358152fleec_ed
fleeches16287082fleeches
flenches163410532flenches
fleshed143210262fle_shed
fletch14388192fletch__
fletchers17335532fletchers
flinched17316702flinched
flitches16388462flitches
frenched17299432frenched
kvetched2142782kvetched
latched133914062_latched
leached133715042_leached
leched123716002_le_ched
leeched13369502_leeched
letches124015482_letches
pleached16338062pleached
retched133814272_retched
sketched1835392sketched
tetched133010772_tetched
wretched17276532wretched
batched154114243_batched
beached154516553_beached
belched154011843_belched
benched154713943_benched
bitched153212923_bitched
blanched16308603blanched
bleacher15358883bleacher
bleaches153410673bleaches
blencher15308393blencher
blenches153310763blenches
blether12459913blet_her
blotches1537433blotches
botched153611903_botched
breached163411643breached
breeched16337383breeched
clencher15277973clencher
clenches152910953clenches
cliched153711023cl_iched
clinched16347383clinched
clothed134010283clot_hed
clutches15307923clutches
crotched16428593crotched
crutched16307463crutched
detached1537733_detached
ditched143711903_ditched
drenched15247913drenched
eched116919223__e_ched
elected102812613ele_cted
etcher113912943__etcher
etches114217763__etches
faithed1437163fait_hed
felted103714653felt__ed
fenced124412713f_enc_ed
fetch134913473f_etch__
fetchers16328863f_etchers
feted94420933f_et__ed
fetiches1636953f_etiches
fetted104817893f_et_ted
fettled11378933f_ettled
filched16307423f_ilched
fileted1159093filet__ed
fitchee152710783f_itchee
fitches153516193f_itches
fitchet153113563f_itchet
fitchew18276803f_itchew
flacked173711583fl_acked
flashed144112183fl_ashed
flatbed13397983flat_bed
flathead1535803flat_head
flatted114012943flat_ted
fledged13417863fle_dged
fleece11369903fleec_e_
fleecer12368033fleec_er
fleeces12399643fleec_es
fleech14367343fleech__
fleecier1334763fleecier
fleered11309503fle_ered
fleeted113310233fle_eted
flemished1853633flemished
flench144010813flench__
flensed1136613fle_nsed
flesher133610923fle_sher
fleshes133913273fle_shes
fletching18256143fletching
flexed17419093fle__xed
fleyed13408813fle__yed
flicked174610673fl_icked
flincher16256583flincher
flinches16358953flinches
flitch14928173flitch__
flited104616583flit__ed
flitted114011643flit_ted
flocced15365483fl_occed
flocked174510253fl_ocked
flushed143310973fl_ushed
fluted104917163flut__ed
flysches1933123flysches
flyted13378773flyt__ed
frenches163311633frenches
frescoed1436053frescoed
freshed143312593fre_shed
fretted113411853fret_ted
frothed14288783frot_hed
glitches14296653glitches
glunched1544263glunched
grutched15284673grutched
hatched163414463_hatched
hitched163312253_hitched
hotched163610923_hotched
hutched16359883_hutched
itched123812023__itched
ketches164012193_ketches
klatches17157133klatches
kvetcher2052813kvetcher
kvetches2053583kvetches
latches123320123_latches
latchet123117903_latchet
lathed104718453_lat_hed
leacher124014843_leacher
leaches123319343_leaches
leashed113211163_leashed
lecher113415853_le_cher
leches115421313_le_ches
leeches123911933_leeches
letch105215803_letch__
lethe85717303_let_he_
lethes94818083_let_hes
letted74118543_let_ted
lunched133911823_lunched
lurched13358033_lurched
lynched16376753_lynched
matched153513963_matched
notched134210303_notched
patched153514623_patched
peached154315883_peached
peched144915343_pe_ched
perched154713243_perched
pitched153512923_pitched
pleaches153210433pleaches
plenches153110623plenches
preached163412063preached
quenched2334103quenched
reached134619083_reached
retches123318513_retches
scotched16187933scotched
scutched16186893scutched
seethed113410193seet_hed
sketcher1735433sketcher
sketches1746823sketches
slatches131511523slatches
sleighed1334033sleighed
sleuthed1233813sleuthed
slouched14206743slouched
smutched16165923smutched
snatched14157633snatched
snitched14166863snitched
splotched1742823splotched
stitched14148203stitched
stretched1546213stretched
switched17157133switched
teched124014433_te_ched
teethed11318623teet_hed
thatched1735433thatched
trenched14289853trenched
twitched17155033twitched
unlatched1544213unlatched
vetches153411263_vetches
watched163012823_watched
welched16298833_welched
wenched163910913_wenched
witched163012193_witched
wrenched17748133wrenched
wretches16257283wretches

Search took 9 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.406440125.6
2DLD Change Limit1461621927.53319402.9
3Display Results1921920.0762526.3
 (SQL Overall)1786911928.01522294.6
 
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.