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

296 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
fabbest143803(None) 
abbes96723522_abbes_
abbess10509772_abbess
ablest84721832_ablest
babiest114414752babiest
drabbest13295662drabbest
fabber134814112fabbe_r
fables114921672fables_
fainest10417702fainest
fairest10412292fairest
falsest10310012falsest
fastest102413722fastest
fattest102913062fattest
flabbiest1644202flabbiest
gabbiest1337272gabbiest
gabfest1336452gabfest
rabbet103818652rabbe_t
rabbets11279422rabbets
abbas95918643_abbas_
abbe87627193_abbe__
abbey125714933_abbe_y
abbeys13538423_abbeys
abbot9318453_abb_ot
abbots1039283_abbots
abet610547943_a_be_t
abets75621673_a_bets
abject17137703_abject
ableist9311773_ableist
ables75935543_ables_
abreast9311273_abreast
absent84016993_absent
abyes105518533_abyes_
airest63825263_airest
albeit8314343_albeit
aptest82917513_aptest
arrest63722633_arrest
attest62618613_attest
babbitt1038033babbitt
babbles104416323babbles_
babes95834113ba_bes_
babies106123653babies_
baddest112611143baddest
baldest102313533baldest
barbes104526233barbes_
barbet104427883barbe_t
barbets114915843barbets
barest85327693ba_rest
basest84720493ba_sest
best66355323___best
blest76431723__blest
cabbed135416263cabbe_d
cabbies133115163cabbies_
cables104527553cables_
cablet104429463cable_t
cablets114216343cablets
cabresta1243993cabresta
cabresto1243733cabresto
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
cambist13312113cambist
cobbiest14118523cobbiest
crabbiest1535623crabbiest
dabbed124416143dabbe_d
dabber114816963dabbe_r
dabbers123813213dabbers
dabbles124514773dabbles_
daftest11248943daftest
dampest12411043dampest
dankest122611673dankest
darkest122512623darkest
daubes94913703daubes_
daubiest1138233daubiest
drabbet12319573drabbe_t
drabbets13294823drabbets
dumbest1238743dumbest
earnest7318733earnest
easiest72318773easiest
ebbet93517293_ebbe_t
ebbets10376833_ebbets
fable105824753fable__
fabled124216383fable_d
fabler116115813fable_r
fablers124812613fablers
fabs98635863fa_b_s_
fabulist1347673fabulist
faces106439433fa_ces_
facet106038523fa_ce_t
facets116316653fa_cets
facies113921593facies_
faddiest1338113faddiest
faddist12289643faddist
fades94932863fa_des_
fadges114814023fadges_
faeces114713123faeces_
faggiest132910183faggiest
faintest1139073faintest
fakes126032483fa_kes_
falces115216003falces_
fames105735923fa_mes_
fanciest133612713fanciest
fanes84639893fa_nes_
fanjet16311393fanje_t
fanjets1734803fanjets
fantast10311703fantast
farces115223323farces_
fares85852873fa_res_
farles96025783farles_
farness102912203farness
farthest1499863farthest
fasces114914543fasces_
fascist1239213fascist
fashes124524023fashes_
fast77052313fa___st
fates85139233fa_tes_
fatless103212203fatless
fatness103311293fatness
fattiest113514313fattiest
fauces114916153fauces_
faucet115816553fauce_t
faucets12578443faucets
fauves125610423fauves_
fauvist1336663fauvist
faves115331423fa_ves_
fawniest14287443fawniest
faxes155726653fa_xes_
fazes175527213fa_zes_
featest102715113featest
feeblest1336913feeblest
fellest10313753fellest
fest74949443f___est
fewest12311663f_ewest
feyest12311403f_eyest
fibbed144011553fibbe_d
fibber134811933fibbe_r
fibbers144510603fibbers
fibres114312123fibres_
filbert12411643filbert
finest94321733f_inest
firmest1239273firmest
fittest102510803fittest
flakiest153210543flakiest
flambes14419503flambes_
flamiest133111973flamiest
flattest1138713flattest
flawiest14298573flawiest
flaxiest18298183flaxiest
fliest94718433f_liest
flybelt1594453flybelt
foamiest13289853foamiest
fobbed144112613fobbe_d
fondest11312403fondest
forest94926743f_orest
foulest10313313foulest
foxiest174310493foxiest
foziest194110943foziest
frailest1139493frailest
frankest1536963frankest
freest95318283f_reest
fubbed144711243fubbe_d
fubsiest13258413fubsiest
fullest10313343fullest
fumiest12312193fumiest
funest94316863f_unest
funfest13348083funfest
funnest102912003funnest
gabbart1248883gabbart
gabbed125216893gabbe_d
gabber114916603gabbe_r
gabbers124612833gabbers
gabbles124415413gabbles_
gabfests1442383gabfests
gabies93820733gabies_
gables94222333gables_
gambes116318313gambes_
gamest94919923ga_mest
gamiest102816223gamiest
gashest114813413gashest
gayest104314333ga_yest
gibbet114113383gibbe_t
gibbets12417723gibbets
glibbest1343683glibbest
gobbet114214443gobbe_t
gobbets12327643gobbets
grabbiest1435323grabbiest
haddest122711993haddest
halbert12314503halbert
halest94823273ha_lest
hardest113118413hardest
harvest132112753harvest
haziest193313003haziest
jabbed184213483jabbe_d
jabber173713643jabbe_r
jabbers183610583jabbers
jambes175914053jambes_
kibbes143811193kibbes_
labret8320223labre_t
labrets939363labrets
laciest93819033laciest
lakiest113517263lakiest
lambast11129893lambast
lambent113711303lambent
lambert113617113lambert
lambiest122410183lambiest
lamest84722763la_mest
lankest112714113lankest
largest83715103largest
latest63822703la_test
laxest134913363la_xest
laziest163814473laziest
mabes96331533ma_bes_
maddest112311213maddest
matiest92522453matiest
maybes1339243maybes_
mayest114614793ma_yest
maziest183613873maziest
nabbed115113613nabbe_d
nabber104913543nabbe_r
nabbers113710463nabbers
nabes75427093na_bes_
nabobess1242203nabobess
naivest10309473naivest
nobbiest12117773nobbiest
noblest93613563noblest
nubbiest12117313nubbiest
numbest1138793numbest
oakiest112913923oakiest
obtest81213013_obtest
orbiest9312413orbiest
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
rabbies113416053rabbies_
rabbis102613163rabbis_
rabbit102914563rabb_it
rabbits11299863rabbits
rabbles113517973rabbles_
rabies85226023rabies_
raciest92820013raciest
rankest112713813rankest
rarest65725483ra_rest
rashest103916873rashest
rawest93615063ra_west
rebbes10313533rebbes_
ribbiest1237583ribbiest
rubiest92914423rubiest
sabbat10314713sabb_at
sabbats1138633sabbats
sabbed114518083sabbe_d
sabes76437463sa_bes_
sables85026693sables_
sabres85520863sabres_
saddest92412383saddest
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saltest71916513saltest
sanest64426693sa_nest
sayest94217743sa_yest
scabbiest1534913scabbiest
shabbiest1635323shabbiest
stablest103312943stablest
subtest9513963subtest
tabbed114215363tabbe_d
tabbies112913503tabbies_
tabbis102910863tabbis_
tabes76033923ta_bes_
tables84524893tables_
tablet84227643table_t
tablets94714383tablets
tallest7317093tallest
tamest85721293ta_mest
tannest72617853tannest
tartest72517533tartest
tautest72612443tautest
tubbiest12117293tubbiest
unblest9411813unblest
vaguest1137333vaguest
vainest10315763vainest
vastest102911513vastest
wabbles144013993wabbles_
wabbliest16274963wabbliest
wackest164710863wackest
waniest103819113waniest
wannest103915003wannest
wariest105122503wariest
warmest123113033warmest
wattest102412153wattest
waviest134513073waviest
waxiest173510883waxiest
webbiest1535353webbiest
yabber136111833yabbe_r
yabbers14389353yabbers
yabbies14279643yabbies_
yarest95018913ya_rest
zaniest163214773zaniest

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.390458182.1
2DLD Change Limit1340272965.86022871.5
3Display Results2962960.1102690.9
 (SQL Overall)1786912966.36028096.1
 
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.