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

171 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
fleeches1628708(None) 
fleches153411441fl_eches
fleeces12399641fleec_es
fleeched17345821fleeched
flenches163410531flenches
fletches16308851fletches
leeches123911931_leeches
beeches143413882_beeches
bleaches153410672bleaches
blenches153310762blenches
breeches15258672breeches
clenches152910952clenches
fetches153413892f_etches
fleche14299302fl_eche_
fleece11369902fleec_e_
fleeced13358152fleec_ed
fleecer12368032fleec_er
fleecers13325932fleecers
fleech14367342fleech__
fleecier1334762fleecier
fleeciest1434872fleeciest
flenched17267962flenched
fleshes133913272fl_eshes
fletched17306692fletched
fletcher16306662fletcher
fletchers17335532fletchers
flinches16358962flinches
flitches16388462flitches
flysches1933122flysches
frenches163311632frenches
leaches123319342_leaches
leches115421312_l_eches
leeched13369502_leeched
letches124015482_letches
pleaches153210432pleaches
plenches153110632plenches
speeches1537412speeches
beaches144120653_beaches
beechen14367703_beechen
belches143514343_belches
benches143918603_benches
beseeches1643953beseeches
blanches153311613blanches
bleached16378563bleached
bleacher15358883bleacher
bleachers16297923bleachers
blenched16358053blenched
blencher15308393blencher
blenchers16356723blenchers
blotches1537433blotches
bobeches1744483bobeches
breaches153714123breaches
breeched16337383breeched
caleches15269943caleches
clenched16257763clenched
clencher15277973clencher
clenchers16276553clenchers
cliches144213743cl_iches
clinches153910373clinches
cloches144113713cl_oches
clutches15307923clutches
creches14313093_creches
creeshes1336953creeshes
drenches14309803drenches
eches106322163___eches
elenchus1343643elenchus
etches114217763__etches
faeces114713123f_aec_es
feces105625363f__ec_es
feezes184412613f_ee_zes
fences114617113f_enc_es
fescues1236783f_escues
fetched163710473f_etched
fetcher153510393f_etcher
fetchers16328863f_etchers
fetiches1636953fetiches
fiches145219533f__iches
filches153410723f_ilches
finches153914193f_inches
fitches153516193f_itches
flashes133916103fl_ashes
flecked17358073fl_ecked
flecks154310803fl_ec_ks
fledges12409393fl_edges
fleeching18305013fleeching
fleecily1644013fleecily
fleecing14347573fleecing
fleecy14266483fleec__y
fleered11309503flee_red
fleers96015793flee__rs
flees85828753fl_e__es
fleeted113310233flee_ted
fleeter103210363flee_ter
fleetest1136723flee_test
fleetness1244753fleetness
fleets96915063flee__ts
flemishes1765243flemishes
flench144010813flench__
flenses1039473fl_enses
fleshed143210263fl_eshed
flesher133610923fl_esher
fleshers14339443fl_eshers
fletch14388193fletch__
flexes164512953fl_e_xes
flexures1843423flexures
flinched17316703flinched
flincher16256583flincher
flinchers17295473flinchers
flitched17256293flitched
fluencies1445933fluencies
flushes134114143fl_ushes
freebees1345353freebees
freebies1337873freebies
freezes193310353free_zes
frenched17299433frenched
frescoes1357833frescoes
freshes133515823f_reshes
glitches14296663glitches
glunches1436263glunches
kenches163912273_kenches
ketches164012193_ketches
klatches17157143klatches
kvetches2053583kvetches
laches116528353_l_aches
larches124416453_larches
latches123320133_latches
leached133715043_leached
leacher124014843_leacher
leachers133712813_leachers
leashes103514403_leashes
leched123716003_l_eched
lecher113415853_l_echer
lechers123313963_l_echers
lechwes1535063_l_echwes
leech104913213_leech__
letched133912053_letched
lethes94818083_l_ethes
liches114724293_l_iches
loaches123613983_loaches
lunches124115443_lunches
lurches123311663_lurches
lyches144213613_l_yches
lynches15378873_lynches
merches144013763_merches
peaches144120053_peaches
perches143717953_perches
planches153111873planches
pleached16338063pleached
preaches153214893preaches
quenches2236013quenches
reaches123423203_reaches
reechoes1338413_reechoes
retches123318513_retches
screeches1695653screeches
seethes103613743_seethes
seiches12513813_seiches
sketches1746823sketches
slatches131511533slatches
sleeves103311343slee_ves
slouches13208073slouches
sneeshes1136513sneeshes
stenches132110293stenches
teaches122718353_teaches
teethes103611653_teethes
tenches123515523_tenches
trenches133512603trenches
vetches153411263_vetches
welches153710313_welches
wenches152914133_wenches
wrenches163210233wrenches
wretches16257283wretches

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 Limit1461621716.51322441.6
3Display Results1711710.0632714.3
 (SQL Overall)1786911716.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.