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

519 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
obtest8121301(None) 
obtect10129631obtect
obtests9136231obtests
oftest91212001oftest
ablest84721832ablest
aptest82917512aptest
attest62618612attest
best66355322_b_est
blest76431722_blest
contest93523232contest
cutest85820142cutest
detest74122842detest
hottest10411382hottest
latest63822702latest
mostest9314792mostest
mutest84218052mutest
noblest93613562noblest
obes66036832ob_es_
obese75212422ob_ese
object17135802object
objet141213142obje_t
objets15125322objets
oblast8613662oblast
oboes75717712oboes_
oboist8312682oboist
obsess845942obsess
obtested1135452obtested
obtuse8147482obtuse
obtusest1044572obtusest
obvert11412992obvert
octet7324062octe_t
octets839402octets
oddest81710862oddest
oldest72114092oldest
orbiest9312412orbiest
outeat62824532outeat
outset64027452outset
retest64028452retest
softest10310602softest
subtest9513962subtest
test48651622__test
abates85825033abates_
abbes96723523abbes_
abbess10509773abbess
abet610547943ab_e_t
abets75621673abets_
abject17137703abject
ableist9311773ableist
ables75935543ables_
abreast9311273abreast
absent84016993absent
abyes105518533abyes_
acutest94410603acutest
airest63825263airest
antes56334323antes_
arrest63722633arrest
artiest73121993artiest
artist64125543artist
ates45047923_ates_
attent62818323attent
attests7278813attests
autist64324943autist
babiest114414753babiest
barest85327693barest
basest84720493basest
bast66362413_b_ast
bates75846343bates_
beast76338643_beast
beat66168303_b_eat
bees65453383_bees_
beet66457543_b_eet
beets76131443_beets
behest11314613behest
belt65754033_b_elt
bent67759913_b_ent
bes56557433_b_es_
beset76739133_b_eset
besot76429713_b_esot
bests75932613_b_ests
bet58376673_b_e_t
bets67051443_bets_
bites75641173bites_
blast76532573_blast
bleat75737003_bleat
blent76230953_blent
bless75917813_bless
blet66247673_ble_t
blets75324943_blets
bluest84016483bluest
boast75935703_boast
bodes84935103bodes_
boites84322703boites_
boldest102613063boldest
boles75448603boles_
bones76446533bones_
boneset9316433boneset
boniest93318993boniest
boost75132473_boost
bores76448253bores_
botas75328783botas_
botel75121863bote_l
botels84815803botels
bots66453953bot_s_
bott66548573bot__t
botts75224863botts_
boxes145625073boxes_
boxiest163711983boxiest
breast8319633_breast
brent75734133_brent
burst75332243_burst
bust65947783_b_ust
butes714535873butes_
byes95230533_byes_
bytes105217493bytes_
cates75951873cates_
cetes75731103cetes_
chest104926143_chest
cites74435583cites_
coattest1038853coattest
cobbiest14118523cobbiest
cobles104622883cobles_
coldest102514753coldest
comtes106222813comtes_
congest104618773congest
content94326153content
contes84432913contes_
contests103413383contests
context163913433context
coolest9318643coolest
cosiest93819853cosiest
cotes76347843cotes_
couthest13312083couthest
cowiest123614673cowiest
coyest11316053coyest
coziest184014353coziest
crest74632693_crest
curtest9713963curtest
cutes79438313cutes_
cutesy114810733cutesy
daftest11248943daftest
dates65639153dates_
deftest112611713deftest
detect94217403detect
detent73624483detent
detests83711743detests
devest104418703devest
digest84019623digest
direst75024243direst
dites66339153dites_
divest106820073divest
dobies94422093dobies_
doest65829523_doest
dopiest103315993dopiest
dotes65836693dotes_
dotiest83717453dotiest
dottiest92611393dottiest
dourest8312943dourest
doziest174012473doziest
drest65530343_drest
driest74722753driest
dryest104811123dryest
ebbet93517293ebbe_t
ebbets10376833ebbets
egest65222343_egest
eldest72912683eldest
extent132714913extent
fabbest1438033fabbest
fastest102413723fastest
fates85139233fates_
fattest102913063fattest
featest102715113featest
fest74949443__fest
fetes85630143fetes_
fewest12311663fewest
feyest12311403feyest
finest94321733finest
fittest102510803fittest
fliest94718423fliest
fondest11312403fondest
footiest113514913footiest
footrest11308853footrest
forest94926743forest
fortes95327183fortes_
foulest10313313foulest
foxiest174310493foxiest
foziest194110943foziest
freest95318283freest
funest94316863funest
gabfest1336453gabfest
gamest94919923gamest
gates65939503gates_
gayest104314333gayest
geest64829613_geest
gest56149133__gest
gites65630183gites_
gobbet114214443gobbe_t
gobbets12327643gobbets
gobies95418063gobies_
goblet93219483goble_t
goblets103210183goblets
goboes95914443goboes_
goldest92411173goldest
gooiest82813883gooiest
goriest82218743goriest
goutiest93013883goutiest
guest65225923_guest
halest94823273halest
hates86742573hates_
hest75950773__hest
hoboes114717443hoboes_
hokiest144114243hokiest
holiest104319623holiest
homiest124116633homiest
honest94822423honest
hootiest113115643hootiest
hostess103210233hostess
hugest10311763hugest
iciest82914743iciest
idlest74014863idlest
illest63615723illest
incest82918743incest
infest93315433infest
ingest73119003ingest
intent63122773intent
invest93014843invest
iratest7312483iratest
jest116738503__jest
jetes124922843jetes_
jobless16237563jobless
jokiest18379193jokiest
joltiest15249403joltiest
justest1449893justest
jutes125125133jutes_
kites95432543kites_
kytes125012913kytes_
lamest84722763lamest
latent64124303latent
latests73910313latests
laxest134913363laxest
leftest10269463leftest
lest46956323__lest
likest104914383likest
lithest10513913lithest
livest95315733livest
lobes75331003lob_es_
loftiest1139083loftiest
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
nites55736343nites_
nobbiest12117773nobbiest
nobles83319723nobles_
nosiest73415673nosiest
notes55034583notes_
nudest74113833nudest
oakiest112913923oakiest
oases55330983oases_
oast47156323o__ast
oaten55222403oate_n
oater55433733oate_r
oaters65029783oaters
oaths86117313oaths_
oats46554213oat_s_
oaves84925613oaves_
obas65730933ob_as_
obe56638643ob_e__
obeah1038993ob_eah
obeli73711933ob_eli
obento837893ob_ento
obesity1275653ob_esity
obey96521303ob_e_y
obeys107010643ob_eys
obias76116863obias_
obiism1036363obiism
obis66226843ob_is_
obit66837083ob__it
obits74617553obits_
objects18123693objects
oblasti945943oblasti
oblasts947293oblasts
oblates91913243oblates_
oboe66822943oboe__
oboists937903oboists
oboles83815833oboles_
obols73715863obols_
obtain839183obtain
obtected1344553obtected
obtesting1245883obtesting
obtund945583obtund
obtuser9134453obtuser
obtusity1343683obtusity
obverse1234753obverse
obverts1235403obverts
octant81216553octant
octette946423octette
odes57243243o_des_
odist6421913o_dist
oes35866193o__es_
offset1238373offset
often84611413ofte_n
oftenest1148863oftenest
ofter84116873ofte_r
ogees65119143ogees_
ogles65223183ogles_
ogres65818633ogres_
ogress7529503ogress
oiliest72817683oiliest
okes84936343o_kes_
oles46453473o_les_
ombres103911143ombres_
oncet74626543once_t
ones46146533o_nes_
onset54730173onse_t
onsets64013543onsets
oocyst1136133oocyst
oots46446443oot_s_
oozes145418713oozes_
ooziest163411523ooziest
openest9312913openest
opes65942613o_pes_
opted84914273opte_d
opts68124743opt_s_
orates64328613orates_
orbless937493orbless
ores46056683o_res_
orgeat7515033orgeat
orient6322533orient
orles55326213orles_
orts46538333ort_s_
oses46641513o_ses_
osteal6312953osteal
otter54423973otte_r
otters64021513otters
ottos54714323ottos_
oust46747443o__ust
outact8317203outact
outask1039103outask
outcast91013743outcast
outeats72215703outeats
outed65429063oute_d
outer55633303oute_r
outers64230163outers
outfast101412123outfast
outfeast11107503outfeast
outfelt10310603outfelt
outfit93014943outfit
outhit92818463outhit
outjut13610053outjut
outkept1337883outkept
outlast71015443outlast
outlet63728683outlet
outlets73616363outlets
outmost9511213outmost
outpost9612443outpost
output8712853output
outs45746963out_s_
outsat62920283outsat
outsee63121803outsee
outsert72819513outsert
outsets73514923outsets
outsit63620883outsit
outwent10311363outwent
outwept1237933outwept
outwit93014583outwit
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
ripest84317933ripest
rites54442553rites_
robes75133303rob_es_
robles85321693robles_
robust8310433rob_ust
robustest1143973robustest
rootiest83115593rootiest
ropiest93317773ropiest
rosiest73919213rosiest
rotes56143903rotes_
rottes64524833rottes_
routes66129313routes_
rubiest92914423rubiest
rudest74016313rudest
safest95016603safest
sagest74920263sagest
saltest71916513saltest
sanest64426693sanest
sates54949323sates_
sayest94217743sayest
serest64831613serest
shiest95821523shiest
shortest11310773shortest
shyest125511833shyest
sites56045433sites_
sliest66621943sliest
slyest93811363slyest
sobeit8315343sob_eit
soberest10310353soberest
soonest7415593soonest
soothest113312243soothest
sootiest84016753sootiest
sorest65027993sorest
sourest7515713sourest
stent55634513_stent
stet45947323_ste_t
stets55423913_stets
stoutest837613stoutest
subtests1037533subtests
subtext1647653subtext
subtlest10511353subtlest
surest65026763surest
tamest85721293tamest
tartest72517533tartest
tates55444983tates_
tautest72612443tautest
teat45963633__teat
tent46159863__tent
testa54822043__testa
tests56530193__tests
testy85419063__testy
tet39274983__te_t
tets45847453__tets
text116033933__text
tobies84521023tobies_
toniest73218903toniest
tortes64826053tortes_
tost48351923__tost
totes55139683totes_
tritest7315273tritest
truest64816193truest
unblest9411813unblest
unrest62918853unrest
urtext1337433urtext
utes45930883_utes_
vastest102911513vastest
vest75743603__vest
vilest9416843vilest
voltes94915583voltes_
votes84627083votes_
wattest102412153wattest
weest85026773_weest
west75748083__west
wettest10239363wettest
whitest133710113whitest
widest104517003widest
wisest95016443wisest
wites85536963wites_
wombiest1536893wombiest
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.1401276364.3
2DLD Change Limit1127165196.37617678.2
3Display Results5195190.1703052.9
 (SQL Overall)1786915196.68626726.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.