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

374 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
iratest731248(None) 
bravest124211752bravest
brawest123810482brawest
crates85736062crates_
featest102715112featest
grates75429892grates_
gravest114011632gravest
grayest11489362grayest
greatest939862greatest
inanest72115362inanest
irades74517392irades_
irate55627982irate__
irately1047682irately
irater65218352irate_r
latest63822702_latest
neatest72516002neatest
orates64328612orates_
pirates93020332pirates_
prates84633162prates_
pretest9517632pretest
protest9317532protest
rarest65725482_rarest
rates55352012_rates_
rawest93615062_rawest
retest64028452_retest
tartest72517532tartest
tritest7315272tritest
urates65027762urates_
abates85825033abates_
acutest94410603acutest
aerates74627493aerates_
agates76121343agates_
airdates939723airdates_
airest63825263air__est
airiest74221013air_iest
alates64833963alates_
amirates101114793amirates_
anapest9311553anapest
aptest82917513_aptest
arabesk1332863arabesk
arames84622573arames_
arbalest1039523arbalest
aretes64425353aretes_
aridest8316143aridest
armrest9310163armrest
arrest63722633ar_rest
artiest73121993artiest
artist64125543ar_tist
ates45047923__ates_
attest62618613_attest
barest85327693_barest
basest84720493_basest
bates75846343_bates_
berates94126873berates_
borates94823013borates_
braces108427773braces_
braes75735053bra_es_
braggest1296533braggest
brakes124923123brakes_
brakiest143912243brakiest
braless92910563braless
brashest133511763brashest
brats75336013brat_s_
brattiest1148103brattiest
braves115524083braves_
brazes175522193brazes_
broadest1138573broadest
brutes86118683brutes_
carates95630613carates_
cartes86239473cartes_
cates75951893_cates_
cerates95428253cerates_
chastest1349703chastest
citrates102315093citrates_
coattest1038863coattest
contest93523233contest
craftiest1436913craftiest
crakes124921813crakes_
cranes84330753cranes_
crankest1438143crankest
crapes104727693crapes_
crases85532313crases_
crassest103411523crassest
crate76537403crate__
crated94827773crate_d
crater85026643crate_r
craters95021893craters
craves115825393craves_
crazes174720133crazes_
craziest19319923craziest
creates95225203creates_
crest74632693cr__est
crudest104510333crudest
curates95323833curates_
curtest9713963curtest
cutest85820143_cutest
daftest11248943daftest
darkest122512623darkest
dates65639153_dates_
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deftest112611713deftest
derates84028893derates_
detest74122843_detest
dilates83220663dilates_
directest1246303directest
direst75024243dir__est
dirtiest93014203dirtiest
disrates91118153disrates_
drabbest13295663drabbest
draftiest1335943draftiest
drakes114715863drakes_
drapes95419653drapes_
drats66628373drat_s_
drest65530343dr__est
driest74722753dr_iest
dryest104811123dr_yest
earnest7318733earnest
elates65032363elates_
emirates101214853emirates_
enates64026433enates_
erases64425403erases_
ergates8314493ergates_
etatist7415033etatist
exactest1745453exactest
farthest1499863farthest
fastest102413723fastest
fates85139233_fates_
fattest102913063fattest
firmest1239273fir_mest
firriest112310433firriest
fittest102510803fittest
fixates1737393fixates_
flattest1138713flattest
frailest1139493frailest
frames115119863frames_
frankest1536963frankest
frater94520593frate_r
fraters103517213fraters
frats86829673frat_s_
freest95318283fr_eest
frites94922483frites_
gamest94919923_gamest
gates65939513_gates_
gayest104314333_gayest
girliest93010403girliest
graces94523493graces_
grades84926313grades_
grandest10311573grandest
grapes95123123grapes_
grapiest112211923grapiest
grate64932883grate__
grated84523923grate_d
grater74625443grate_r
graters85419743graters
gratis74819243gratis_
graves104624003graves_
grazes164519643grazes_
greyest11348343greyest
gyrates113610263gyrates_
halest94823273_halest
hardest113118413hardest
harvest132112753harvest
hates86742573_hates_
hottest10411383hottest
iciest82914743i_ciest
ickiest133611043ickiest
ideates8313733ideates_
idlest74014863i_dlest
iffiest1337963iffiest
ikats95311153ikat_s_
illest63615723i_llest
images91411463images_
imagist1077333imagist
imaret81121233imare_t
imarets9138643imarets
imprest11310203imprest
inanes62519803inanes_
incest82918743i_ncest
infest93315433i_nfest
ingates82716913ingates_
ingest73119003i_ngest
ingrates9514173ingrates_
inkiest113415043inkiest
inmates92715783inmates_
inquest1638603inquest
insanest8410343insanest
intent63122773i_ntent
invest93014843i_nvest
iodates8312903iodates_
irade65618153irade__
irateness9310493irateness
ireless72312243ireless
ires45639283ir__es_
irides74519123irides_
irises64221173irises_
iritis63113733iritis_
irones64724013irones_
ironist7314843ironist
iterates81317823iterates_
justest1449893justest
karateist1345023karateist
karates115617473karates_
krater104014313krate_r
kraters114212343kraters
lamest84722763_lamest
largest83715103largest
latent64124303_latent
latests73910313_latests
laxest134913363_laxest
leanest7415863leanest
leftest10269463leftest
librates103412953librates_
ligates82318383ligates_
lightest121410353lightest
mates75251363_mates_
matiest92522453_matiest
mayest114614793_mayest
meanest9315703meanest
meatiest102816793meatiest
migrates111112853migrates_
minutest10247653minutest
mirages102213533mirages_
miriest93619823mir_iest
mirkest13309723mir_kest
mirkiest142910253mirkiest
misrates101318243misrates_
mostest9314793mostest
mutest84218053_mutest
nates55238333_nates_
nearest73415843nearest
nidates8311893nidates_
nitrates82516223nitrates_
obtest81213013_obtest
oftest91212003_oftest
oralist7619633oralist
orate55133303orate__
orated74221503orate_d
oratress834553oratress
orbiest9312413orbiest
palest83926223_palest
patent84524923_patent
pates76047893_pates_
peartest10311303peartest
peatiest103118803peatiest
pertest9317043pertest
phattest1336913phattest
picrates122013213picrates_
pirate82322883pirate__
pirated102515613pirate_d
plates85432243plates_
platiest103216083platiest
prases84429023prases_
prate75135983prate__
prated94924923prate_d
prater84825353prate_r
praters94921653praters
prats76333393prat_s_
praxes156215183praxes_
prest75736353pr__est
pretests10310013pretests
pretext1639663pretext
priest84125423pr_iest
privatest14196733privatest
protect11313633protect
protests10310493protests
protist9320223protist
prowest12311533prowest
races74943243_races_
raciest92820013_raciest
racist82822793_racist
rages64539443_rages_
rajes125022783_rajes_
rakes94440353_rakes_
rales54947493_rales_
ramet75743143_rame_t
ramets83517393_ramets
rankest112713813_rankest
rapes75740723_rapes_
rapist82520673_rapist
rares55247443_rares_
rases55447213_rases_
rashest103916873_rashest
rate45458763_rate__
rated65441383_rate_d
ratel54224883_rate_l
ratels64518213_ratels
rater54943283_rate_r
raters63936583_raters
ratos55528763_ratos_
rats46260373_rat_s_
rattiest83516113_rattiest
raves85441973_raves_
raxes124729393_raxes_
razes145032703_razes_
realest73322433realest
reest54938093_r_eest
renest64529713_renest
rest46459843_r__est
retests73813853_retests
revest94623603_revest
riatas63915093riatas_
richest122813683richest
rifest93114583_rifest
rightest12149583rightest
rimiest93215853rimiest
ripest84317943_ripest
rites54442553_rites_
rotes56143903_rotes_
rudest74016313_rudest
safest95016603_safest
sagest74920263_sagest
saltest71916513saltest
sanest64426693_sanest
sates54949323_sates_
sayest94217743_sayest
scantest101710183scantest
searest73322023searest
sedatest9249393sedatest
skates104219403skates_
slates64934063slates_
slatiest82616263slatiest
smartest10310183smartest
softest10310603softest
sparest94616423sparest
spates85028173spates_
stalest73720173stalest
states64337083states_
statist7317723statist
straitest949173straitest
suavest10310623suavest
subtest9513963subtest
tamest85721293_tamest
tartiest82718313tartiest
tates55444983_tates_
tautest72612443tautest
test48651623___test
tightest12148363tightest
tirades8311723tirades_
tiredest938403tiredest
titrates82314663titrates_
traces85329933traces_
trades75724503trades_
traject1637043traject
trapes85024463trapes_
trapnest10310923trapnest
traves94222743traves_
travesty1444483travesty
truest64816193tr_uest
uprates93814863uprates_
urares64519093urares_
urases63723563urases_
urate55432163urate__
urbanest10117533urbanest
urtext1337433ur_text
vastest102911513vastest
vibrates132210613vibrates_
virgates1237923virgates_
wariest105122503wariest
warmest123113033warmest
wartiest113614643wartiest
wattest102412153wattest
weakest1439003weakest
wettest10239363wettest
whitest133710113whitest
wiriest103816853wir_iest
wrathiest1536973wrathiest
wraths123810083wraths_
wrest84925433wr__est
wriest94419713wr_iest
writes94420333writes_
wryest12429113wr_yest
yarest95018913_yarest

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 Limit1340273746.09321996.9
3Display Results3743740.1262968.3
 (SQL Overall)1786913746.62526972.2
 
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.