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

481 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
oftest9121200(None) 
obtest81213011obtest
softest10310601softest
aptest82917512aptest
attest62618612attest
contest93523232contest
cutest85820142cutest
daftest11248942daftest
deftest112611712deftest
detest74122842detest
fest74949442_f_est
forest94926742forest
hottest10411382hottest
latest63822702latest
leftest10269462leftest
loftiest1139082loftiest
mostest9314792mostest
mutest84218052mutest
obtect10129632obtect
obtests9136232obtests
octet7324062octe_t
octets839402octets
oddest81710862oddest
offset1238372offset
often84611412ofte_n
oftenest1148862oftenest
ofter84116872ofte_r
oldest72114092oldest
outeat62824532outeat
outset64027452outset
retest64028452retest
test48651622__test
ablest84721833ablest
acutest94410603acutest
affect1448903affect
afreet9315153afreet
afresh1255503afresh
after85719793afte_r
afters94717073afters
aftmost1244973aftmost
aftosa996573aftosa
airest63825263airest
antes56334323antes_
arrest63722633arrest
artiest73121993artiest
artist64125543artist
ates45047923_ates_
attent62818323attent
attests7278813attests
autist64324943autist
barest85327693barest
basest84720493basest
bates75846343bates_
behest11314613behest
best66355323__best
bites75641173bites_
blest76431723_blest
bluest84016483bluest
boites84322703boites_
boldest102613063boldest
boniest93318993boniest
boxiest163711983boxiest
buffest15298643buffest
butes714535873butes_
bytes105217493bytes_
cates75951893cates_
cetes75731103cetes_
chest104926143_chest
cites74435593cites_
coattest1038863coattest
coldest102514763coldest
comfiest1539133comfiest
comtes106222813comtes_
congest104618773congest
content94326153content
contes84432913contes_
contests103413383contests
context163913433context
coolest9318643coolest
cosiest93819853cosiest
cotes76347843cotes_
couthest13312083couthest
cowiest123614673cowiest
coyest11316053coyest
coziest184014353coziest
crest74632693_crest
curtest9713963curtest
cutes79438323cutes_
cutesy114810733cutesy
dates65639153dates_
deffest14308803deffest
detect94217403detect
detent73624483detent
detests83711743detests
devest104418703devest
digest84019623digest
direst75024243direst
dites66339153dites_
divest106820073divest
doest65829523_doest
dopiest103315993dopiest
dotes65836693dotes_
dotiest83717453dotiest
dottiest92611393dottiest
dourest8312943dourest
doziest174012473doziest
drest65530343_drest
driest74722753driest
dryest104811123dryest
effect1437443effect
efts76519483eft_s_
egest65222343_egest
eldest72912683eldest
extent132714913extent
fast77052313_f_ast
fastest102413723fastest
fates85139233fates_
fattest102913063fattest
feast85932723_feast
feat76458223_f_eat
featest102715113featest
fees76450603_fees_
feet75352213_f_eet
feist86230073_feist
felt75146933_f_elt
fes66551673_f_es_
fess76529163_f_ess
fests85828043_f_ests
fet66471633_f_e_t
fetes85630143fetes_
fets75345943_fets_
fewest12311663fewest
feyest12311403feyest
fiesta938123_fiesta
finest94321733finest
first86226123_first
fist76248423_f_ist
fittest102510803fittest
fleet85932333_fleet
flesh115013743_flesh
fliest94718433fliest
foes76543443_foes_
foist85730973_foist
foment113718303foment
fondest11312403fondest
footiest113514913footiest
footrest11308853footrest
fores85847103fores_
forests104114953forests
fortes95327183fortes_
foulest10313313foulest
foxes156321093foxes_
foxiest174310493foxiest
foziest194110943foziest
freest95318283freest
fresh115012203_fresh
fret75845043_fre_t
frets85523403_frets
frost84727833_frost
funest94316863funest
gamest94919923gamest
gates65939513gates_
gayest104314333gayest
geest64829613_geest
gest56149133__gest
gites65630183gites_
goldest92411173goldest
goofiest12289393goofiest
gooiest82813883gooiest
goriest82218743goriest
goutiest93013883goutiest
guest65225923_guest
halest94823273halest
hates86742573hates_
heftiest1439183heftiest
hest75950773__hest
hokiest144114243hokiest
holiest104319623holiest
homiest124116633homiest
honest94822423honest
hootiest113115643hootiest
hostess103210243hostess
hugest10311763hugest
iciest82914743iciest
idlest74014863idlest
iffiest1337963iffiest
illest63615723illest
incest82918743incest
infest93315433infest
ingest73119003ingest
intent63122773intent
invest93014843invest
iratest7312483iratest
jest116738503__jest
jetes124922843jetes_
jokiest18379193jokiest
joltiest15249403joltiest
justest1449893justest
jutes125125133jutes_
kites95432543kites_
kytes125012913kytes_
lamest84722763lamest
latent64124303latent
latests73910313latests
laxest134913363laxest
leftist10279353leftist
lest46956323__lest
likest104914383likest
lithest10513913lithest
livest95315733livest
lofted103811893lofte_d
lofter94614723lofte_r
lofters103912903lofters
loftless1135903loftless
lofts85518363loft_s_
logiest82515543logiest
longest84114953longest
loosest75811563loosest
lottes65322753lottes_
loudest839933loudest
lowest93915593lowest
lutes55836663lutes_
lutist64317553lutist
mates75251363mates_
matiest92522453matiest
mayest114614793mayest
merest84725113merest
metes74736213metes_
mites75141803mites_
mitiest93520053mitiest
modest93818453modest
moistest1038763moistest
molest85022743molest
montes84226933montes_
mopiest113014293mopiest
mostests1036833mostests
motes75944003motes_
motet75641193mote_t
motets84216193motets
mottes85523693mottes_
mutes75033783mutes_
nates55238333nates_
neatest72516003neatest
nest45548733__nest
newest9314213newest
nicest82315663nicest
niftiest112910073niftiest
nites55736343nites_
noblest93613563noblest
nosiest73415673nosiest
notes55034583notes_
nudest74113833nudest
oakiest112913923oakiest
oases55330983oases_
oast47156323o__ast
oaten55222403oate_n
oater55433733oate_r
oaters65029793oaters
oaths86117313oaths_
oats46554213oat_s_
oaves84925613oaves_
obes66036833o_bes_
obese75212423o_bese
object17135803object
objet141213143obje_t
objets15125323objets
oblast8613663oblast
oboes75717713oboes_
oboist8312683oboist
obsess845943obsess
obtested1135453obtested
obtuse8147483obtuse
obtusest1044573obtusest
obvert11412993obvert
octant81216553octant
octette946423octette
odes57243243o_des_
odist6421913o_dist
oes35866193o__es_
ofays11488923ofays_
offbeat1564143offbeat
offcast1544473offcast
offcut1444703offcut
offed12359163offe_d
offend13365663offend
offense1343683offense
offer114311383offe_r
offers12349963offers
offish15137273offish
offs107117013of_fs_
offsets1333503offsets
oft67744063of___t
oftener1035923oftener
ogees65119143ogees_
ogles65223183ogles_
ogres65818633ogres_
ogress7529503ogress
oiliest72817683oiliest
okes84936343o_kes_
oles46453473o_les_
oncet74626543once_t
ones46146533o_nes_
onset54730173onse_t
onsets64013543onsets
oocyst1136133oocyst
oots46446443oot_s_
oozes145418713oozes_
ooziest163411523ooziest
openest9312913openest
opes65942613o_pes_
opted84914273opte_d
opts68124743opt_s_
orates64328613orates_
orbiest9312413orbiest
ores46056683o_res_
orgeat7515033orgeat
orient6322533orient
orles55326213orles_
orts46538333ort_s_
oses46641513o_ses_
osteal6312963osteal
otter54423973otte_r
otters64021513otters
ottos54714323ottos_
oust46747443o__ust
outact8317203outact
outask1039103outask
outcast91013743outcast
outeats72215703outeats
outed65429063oute_d
outer55633303oute_r
outers64230173outers
outfast101412123outfast
outfeast11107503outfeast
outfelt10310603outfelt
outfit93014953outfit
outhit92818473outhit
outjut13610073outjut
outkept1337883outkept
outlast71015443outlast
outlet63728683outlet
outlets73616363outlets
outmost9511213outmost
outpost9612443outpost
output8712853output
outs45746963out_s_
outsat62920283outsat
outsee63121803outsee
outsert72819513outsert
outsets73514923outsets
outsit63620893outsit
outwent10311363outwent
outwept1237933outwept
outwit93014593outwit
overt85630723o_vert
owes75137103o_wes_
owlet83324463owle_t
owlets93110393owlets
oxes116530723o_xes_
oxter123414093oxte_r
oxters134813273oxters
oyes74940133o_yes_
palest83926223palest
patent84524923patent
pates76047893pates_
pertest9317043pertest
pest65555293__pest
poetess938933poetess
pokiest133314913pokiest
politest10312943politest
pontes83627853pontes_
poorest9312773poorest
portent93619643portent
poshest12312423poshest
posttest10410233posttest
potent84223353potent
pottiest102815973pottiest
poutiest103016793poutiest
poxiest163412253poxiest
prest75736353_prest
pretest9517633pretest
priest84125423priest
protest9317533protest
purest84021933purest
quest144121323_quest
rarest65725483rarest
rates55352013rates_
rawest93615063rawest
reest54938093_reest
renest64529713renest
rest46459843__rest
retests73813853retests
revest94623603revest
rifest93114583rifest
ripest84317943ripest
rites54442553rites_
rootiest83115593rootiest
ropiest93317773ropiest
rosiest73919213rosiest
rotes56143903rotes_
rottes64524833rottes_
routes66129313routes_
rudest74016313rudest
safest95016603safest
sagest74920263sagest
saltest71916513saltest
sanest64426693sanest
sates54949323sates_
sayest94217743sayest
serest64831613serest
shiest95821523shiest
shortest11310783shortest
shyest125511833shyest
sites56045433sites_
sliest66621953sliest
slyest93811363slyest
softas94410403softas_
soften9429493softe_n
softens10347623softens
softer94015313softe_r
softies103414613softies_
softish13127813softish
softness1136433softness
softs85019233soft_s_
soonest7415593soonest
soothest113312243soothest
sootiest84016753sootiest
sorest65028003sorest
sourest7515713sourest
stent55634513_stent
stet45947323_ste_t
stets55423913_stets
stoutest837613stoutest
subtest9513963subtest
surest65026763surest
swiftest1434353swiftest
tamest85721293tamest
tartest72517533tartest
tates55444983tates_
tautest72612443tautest
teat45963633__teat
tent46159863__tent
testa54822043__testa
tests56530193__tests
testy85419063__testy
tet39274993__te_t
tets45847463__tets
text116033933__text
tofts84919243toft_s_
toniest73218903toniest
tortes64826053tortes_
tost48351923__tost
totes55139683totes_
tritest7315273tritest
truest64816193truest
tuftiest1138283tuftiest
unrest62918853unrest
urtext1337433urtext
utes45930883_utes_
vastest102911513vastest
vest75743603__vest
vilest9416843vilest
voltes94915583voltes_
votes84627083votes_
wattest102412153wattest
weest85026773_weest
west75748083__west
wettest10239363wettest
whitest133710113whitest
widest104517003widest
wiftiest14279173wiftiest
wisest95016443wisest
wites85536963wites_
wrest84925433_wrest
wriest94419713wriest
wryest12429113wryest
wytes114113433wytes_
yarest95018913yarest
zest136035703__zest
zooiest16199923zooiest
zootiest173311213zootiest

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 Filter1786911127160.470380193.6
2DLD Change Limit1127164815.61020092.0
3Display Results4814810.1563083.3
 (SQL Overall)1786914816.23628654.7
 
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.