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

361 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
fittest10251080(None) 
fattest102913061fattest
attest62618612_attest
bittiest103012042bittiest
faintest1139072faintest
fastest102413722fastest
fattiest113514312fattiest
featest102715112featest
finest94321732fi_nest
firmest1239272firmest
fitment12710302fitment
fitness10299392fitness
fitted104716662fitte_d
fitter94120032fitte_r
fitters104517752fitters
flattest1138712flattest
fyttes1236932fyttes_
hottest10411382hottest
kittlest12297572kittlest
lithest10513912lithest
littlest8309242littlest
mitiest93520052mitiest
nittiest82712602nittiest
wattest102412152wattest
wettest10239362wettest
wittiest112711522wittiest
acutest94410603acutest
airest63825263ai_rest
airiest74221013airiest
aptest82917513_aptest
artiest73121993artiest
attent62818323_attent
attests7278813_attests
battiest104115553battiest
biggest1138143biggest
bites75641173bi_tes_
bitsiest102610063bitsiest
bitted94418483bitte_d
bitten84715123bitte_n
bitter84622673bitte_r
bitterest1147713bitterest
bittern94810683bittern
bitters94920363bitters
bitts75022593bitt_s_
blithest1338083blithest
brittlest11146193brittlest
buttes84822563buttes_
cattiest103016333cattiest
cites74435593ci_tes_
cities84524853cities_
cittern9339143cittern
coattest1038863coattest
contest93523233contest
curtest9713963curtest
cutest85820143_cutest
daftest11248943daftest
deftest112611713deftest
detest74122843_detest
diciest103316523diciest
dictiest113212783dictiest
digest84019623di_gest
dimmest1249253dimmest
direst75024243di_rest
dirtiest93014203dirtiest
distent84120853distent
dites66339153di_tes_
ditheist1249493ditheist
ditsiest92111323ditsiest
ditties83116983ditties_
dittos74111973dittos_
ditzes163212423ditzes_
ditziest18218473ditziest
divest106820073di_vest
dotiest83717453dotiest
dottiest92611393dottiest
fabbest1438033fabbest
fainest10417703fainest
fairest10412293fairest
falsest10310013falsest
fantast10311703fantast
farthest1499863farthest
fates85139233f_ates_
fatless103212203fatless
fatness103311293fatness
fatted105419843fatte_d
fatten94314903fatte_n
fattens105111713fattens
fatter94523213fatte_r
fatties103018203fatties_
fattish1359263fattish
feistiest1237073feistiest
fellest10313753fellest
fest74949443f___est
fetes85630143f_etes_
fetted104817893fette_d
fetter94120383fette_r
fetters103517903fetters
fettles103912733fettles_
fewest12311663f_ewest
feyest12311403f_eyest
fiats85324483fiat_s_
fibres114312123fibres_
fices106031163fi_ces_
fiches145219533fiches_
ficklest17267903ficklest
ficoes114613463ficoes_
fideist1139753fideist
fidges114114383fidges_
fidget114216473fidge_t
fidgets12388763fidgets
fiercest13216143fiercest
fieriest112112243fieriest
fiesta938123fi__esta
fifes114822393fi_fes_
fifteen1343923fifteen
fifths15406543fifths_
fifties132111083fifties_
figment1379743figment
filbert12411643filbert
files85441273fi_les_
filet85540163fi_le_t
filets94718953filets_
filles94224523filles_
fillet95027083fille_t
fillets103414753fillets
filmiest1338553filmiest
filmset1257513filmset
filter94517633filte_r
filters103816553filters
filthiest1545373filthiest
filths12389783filths_
fines86644263fi_nes_
finites10315923finites_
finless102810783finless
finniest113011403finniest
fiques1837973fiques_
fires85740753fi_res_
firriest112310433firriest
first86226123fi__rst
firths125113503firths_
fishes125221343fishes_
fishiest14310453fishiest
fist76248423fi___st
fisted104218703fiste_d
fists85527543fist_s_
fitches153516193fitches_
fitchet153113563fitchet
fitchets16307413fitchets
fitments1376793fitments
fits76043463fi_t_s_
fitting113516563fitting
fives116027363fi_ves_
fixates1737393fixates_
fixes154723593fi_xes_
fizzes174512553fizzes_
fizziest19226073fizziest
fleetest1136723fleetest
fliest94718433f_liest
flintiest1248433flintiest
flippest1535173flippest
flirtiest1236193flirtiest
flites95122443flites_
flitted114011643flitte_d
flitter103413903flitte_r
flitters114312173flitters
flutes95421783flutes_
flutiest112610883flutiest
flutist102910783flutist
flytes123911563flytes_
fondest11312403fondest
footiest113514913footiest
footrest11308853footrest
forest94926743f_orest
fortes95327183fortes_
foulest10313313foulest
foxiest174310493foxiest
foziest194110943foziest
freest95318283f_reest
frettiest1267063frettiest
frites94922483frites_
fritted113611333fritte_d
fritter103912773fritte_r
fritters113810783fritters
fritts94613193fritt_s_
fritzes19329453fritzes_
fruitiest1237383fruitiest
fullest10313343fullest
fumiest12312193fumiest
funest94316863f_unest
funfest13348083funfest
funnest102912003funnest
furthest1496863furthest
fustiest113014573fustiest
futzes184313113futzes_
fytte1138583fytte__
gites65630183gi_tes_
gitted84015053gitte_d
gittern8337503gittern
grittiest10176983grittiest
guttiest92311223guttiest
highest1439563highest
hippest14219753hippest
hitless103211193hitless
hitter94419863hitte_r
hitters104717593hitters
iciest82914743_iciest
idlest74014863_idlest
iffiest1337963iffiest
illest63615723_illest
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
intent63122773_intent
invest93014843_invest
iratest7312483iratest
jettiest15359593jettiest
jimpest18297553jimpest
jitter133314993jitte_r
jitters144314473jitters
jittery17346443jittery
jiviest1738113jiviest
justest1449893justest
kindest12311503kindest
kites95432543ki_tes_
kithes135016653kithes_
kitted115114833kitte_d
kittel10368873kitte_l
kitten104611483kitte_n
kittens11347583kittens
kitties113213623kitties_
kittles113012493kittles_
latest63822703_latest
lattes65324203lattes_
leftest10269463leftest
liefest1038443liefest
lievest1048343lievest
lightest121410353lightest
likest104914383li_kest
limiest93716103limiest
limpest113712313limpest
liniest73321153liniest
lintiest82715913lintiest
litotes7311183litotes_
litres65220393litres_
litten64014873litte_n
litter64324853litte_r
litters73422573litters
littery103710493littery
littles73212783littles_
livest95315733li_vest
lottes65322753lottes_
matiest92522453matiest
mattes85624533mattes_
mildest102812063mildest
miltiest103015173miltiest
mintiest103217143mintiest
minutest10247653minutest
miriest93619823miriest
mirkest13309723mirkest
mistiest103018313mistiest
mites75141803mi_tes_
mitres83922073mitres_
mitten83914093mitte_n
mittens9349883mittens
mitts75523753mitt_s_
moistest1038763moistest
mostest9314793mostest
mottes85523693mottes_
mutest84218053_mutest
nattiest83215353nattiest
neatest72516003neatest
nettiest83112433nettiest
nicest82315663ni_cest
niftiest112910073niftiest
nighest11310693nighest
nites55736343ni_tes_
nitres65519333nitres_
nuttiest82312143nuttiest
obtest81213013_obtest
oftest91212003_oftest
oiliest72817683oiliest
pertest9317043pertest
pettiest103113963pettiest
phattest1336913phattest
pietist9414033pietist
piniest93121133piniest
pinkest132812623pinkest
pipiest113114493pipiest
pistes85325633pistes_
pithiest132711443pithiest
pities83828083pities_
pittas86014523pittas_
pitted94319593pitte_d
posttest10410233posttest
pottiest102815973pottiest
pretest9517633pretest
protest9317533protest
quietest1757173quietest
rattiest83516113rattiest
retest64028453_retest
richest122813683richest
rifest93114583ri_fest
rightest12149583rightest
rimiest93215853rimiest
ripest84317943ri_pest
rites54442553ri_tes_
ritter63822423ritte_r
ritters74020623ritters
ritzes154812943ritzes_
ritziest17237843ritziest
rottes64524833rottes_
ruttiest82712663ruttiest
saltest71916513saltest
shittiest1238333shittiest
sickest131813793sickest
siltiest83515613siltiest
sites56045433si_tes_
sitten64113823sitte_n
sitter63323383sitte_r
sitters74221553sitters
sixtes133612403sixtes_
siziest16311473siziest
slittiest938203slittiest
softest10310603softest
subtest9513963subtest
swiftest1434353swiftest
tartest72517533tartest
tattiest83415383tattiest
tautest72612443tautest
test48651623___test
tidiest83514873tidiest
tightest12148363tightest
tiniest73020123tiniest
tithes94720213tithes_
titles63719923titles_
titlist7312923titlist
titres64718933titres_
titter63421163titte_r
titters74219623titters
titties73617363titties_
tittles73413253tittles_
tritest7315273tritest
vastest102911513vastest
vilest9416843vi_lest
viniest103216613viniest
vittles103211113vittles_
whitest133710113whitest
whitiest14259883whitiest
widest104517003wi_dest
wiftiest14279173wiftiest
wildest113311273wildest
wiliest103416593wiliest
winiest103419693winiest
wiriest103816853wiriest
wisest95016443wi_sest
wites85536963wi_tes_
withes124620843withes_
withiest142411243withiest
witless103310983witless
witness103010013witness
witted104216813witte_d

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273615.84322938.0
3Display Results3613610.1432524.5
 (SQL Overall)1786913616.39227955.4
 
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.