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

139 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
fleeched1734582(None) 
fleeced13358151fleec_ed
fleeches16287081fleeches
flenched17267961flenched
fletched17306691fletched
leeched13369501_leeched
bleached16378562bleached
blenched16358052blenched
breeched16337382breeched
clenched16257762clenched
fetched163710472f_etched
fleche14299302fl_eche_
fleches153411442fl_eches
flecked17358072fl_ecked
fleece11369902fleec_e_
fleecer12368032fleec_er
fleeces12399642fleec_es
fleech14367342fleech__
fleecier1334762fleecier
fleered11309502flee_red
fleeted113310232flee_ted
flenches163410532flenches
fleshed143210262fl_eshed
fletcher16306662fletcher
fletches16308852fletches
flinched17316702flinched
flitched17256292flitched
frenched17299432frenched
leached133715042_leached
leched123716002_l_eched
leeches123911932_leeches
letched133912052_letched
pleached16338062pleached
beached154516553_beached
beechen14367703_beechen
beeches143413883_beeches
belched154011843_belched
benched154713943_benched
beseeched1743203beseeched
blanched16308603blanched
bleacher15358883bleacher
bleaches153410673bleaches
bleeped12287273blee_ped
blencher15308393blencher
blenches153310763blenches
blotched1635653blotched
breached163411643breached
breeches15258673breeches
cleeked14357733clee_ked
clencher15277973clencher
clenches152910953clenches
cliched153711023cl_iched
clinched16347383clinched
clutched16356033clutched
creeshed1435703creeshed
drenched15247913drenched
eched116919223___eched
elected102812613el_ected
etched123613703__etched
feezed19439993f_ee_zed
fenced124412713f_enc_ed
fetcher153510393f_etcher
fetches153413893f_etches
filched16307423f_ilched
flacked173711583fl_acked
flashed144112183fl_ashed
fledged13417863fl_edged
fleecers13325933fleecers
fleeching18305013fleeching
fleeciest1434873fleeciest
fleecily1644013fleecily
fleecing14347573fleecing
fleecy14266483fleec__y
fleeter103210363flee_ter
flemished1853633flemished
flench144010813flench__
flensed1136613fl_ensed
flesher133610923fl_esher
fleshes133913273fl_eshes
fletch14388193fletch__
fletchers17335533fletchers
flexed17419093fl_e_xed
fleyed13408813fl_e_yed
flicked174610673fl_icked
flincher16256583flincher
flinches16358953flinches
flitches16388463flitches
flocced15365483fl_occed
flocked174510253fl_ocked
flushed143310973fl_ushed
flysches1933123flysches
frenches163311633frenches
frescoed1436053frescoed
freshed143312593f_reshed
gleeked13346333glee_ked
gleeted9379323glee_ted
glunched1544263glunched
kvetched2142783kvetched
latched133914073_latched
leacher124014843_leacher
leaches123319343_leaches
leashed113211163_leashed
lecher113415853_l_echer
leches115421313_l_eches
leech104913213_leech__
leered73816223_lee_red
letches124015483_letches
lunched133911823_lunched
lurched13358033_lurched
lynched16376753_lynched
peached154315883_peached
peched144915343__peched
perched154713243_perched
pleaches153210433pleaches
plenches153110623plenches
preached163412063preached
quenched2334103quenched
reached134619083_reached
reechoed1436083_reechoed
retched133814273_retched
screeched17114343screeched
seethed113410193_seethed
selected1159783selected
sketched1835393sketched
sleeked123510883slee_ked
sleeted83113223slee_ted
sleeved11419913slee_ved
sleighed1334033sleighed
sleuthed1233813sleuthed
slouched14206743slouched
speeches1537413speeches
teched124014433__teched
teethed11318623_teethed
tetched133010773_tetched
trenched14289853trenched
welched16298833_welched
wenched163910913_wenched
wrenched17748133wrenched
wretched17276533wretched

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.423422437.4
2DLD Change Limit1461621397.57619292.8
3Display Results1391390.0463021.7
 (SQL Overall)1786911398.04522211.4
 
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.