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

470 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
imaret8112122(None) 
imarets9138641imarets
caret75360562_caret
cigaret10412992cigaret
claret84026572claret
image81411282image_
imaged1097752imaged
imager9108112imager
images91411452images
impart102715132impar_t
imprest11310202imprest
mare64759322_mare_
mares76457632_mares
market123226042_market
mart66865972_mar_t
minaret9520682minaret
smart75834092smar_t
abet610547943__abet
aigret73720023aigret
amaretti1074783amaretti
amaretto10104643amaretto
amarna839793amarna
amaze166016603amaze_
amazed18519303amazed
amazes175613473amazes
amort75832203amor_t
amulet8419573amulet
apart74330673apar_t
are37874573__are_
area45843393__area
ares45871023__ares
arete56031353__arete
armet76739453__armet
art38679143__ar_t
aware86420023aware_
barbet104427883_barbet
bare65460523_bare_
bared85144483_bared
barer74535803_barer
bares75457133_bares
barest85327693_barest
barret84930483barret
bearer85323913bearer
befret11315963befret
beret74946363_beret
blare75826233blare_
blared95018243blared
blares85021633blares
boart78835933boar_t
buret77444013_buret
cabaret112519043cabaret
cadet85339333_cadet
camlet104426583camlet
carat75048793_carat
care66968373_care_
cared86050093_cared
carer74942333_carer
cares77369183_cares
carets85330773_carets
carex144822293_carex
carnet84732873_carnet
carpet104530093_carpet
cart66570343_car_t
carte75940423_carte
chalet113825993chalet
chare105231983chare_
chared125423693chared
chares115631803chares
chart105038283char_t
cigarets1145463cigarets
clarets94111103clarets
curet75447643_curet
dare55848863_dare_
dared75935013_dared
darer65230793_darer
dares66146703_dares
dart55857873_dar_t
dearer74822803dearer
dearest83618673dearest
eared65139503_eared
ecarte84313503ecarte
egret63327313_egret
emmet94221383em_met
facet106038523_facet
fare76354463_fare_
fared95842343_fared
farer86733143_farer
fares85852873_fares
fart76860563_far_t
feared106320433feared
fearer94820183fearer
ferret93021173ferret
filaree10611193filaree
flare84823633flare_
flared105317603flared
flares94521703flares
floret9321123floret
fret75845043__fret
garget84327273_garget
garnet73928413_garnet
garret74426553garret
geared85317743geared
gimlet93716663gim_let
glare65222953glare_
glared84715193glared
glares75518863glares
haet75659503_ha_et
hamlet113722793hamlet
hare76255733_hare_
hared95742183_hared
harem104924453_harem
hares86255543_hares
hart76865773_har_t
hearer94323643hearer
heart85440743hear_t
ikat87626643ika__t
imagers10107753imagers
imagery13124203imagery
imagist1077323imagist
imago8118683ima_go
imagoes10126403imagoes
imagos9117543imagos
imam81718323ima__m
imamate1138093imamate
imams91511103ima_ms
imaum9139633ima_um
imaums10106293imaums
imbark14347843imbar_k
imbarked17254063imbarked
imbarks15326603imbarks
imbed105013633im_bed
imbrue1035133imbrue
imbrued1234683imbrued
imbrues1135493imbrues
imbrute1144903imbrute
imbue939463imbue_
imbued1136153imbued
imbues1037963imbues
imide85716873imide_
imides94515333imides
imine75821043imine_
imines84918343imines
immane1038873immane_
immanent1246803immanent
immies102412423immies
immure1036023immure_
immured1235063immured
immures1136713immures
impact122310443impact
impaint11511213impaint
impaired1335143impaired
impairer1244863impairer
impale102811653impale_
impaled12288503impaled
impaler11298393impaler
impales113311763impales
impanel1137093impanel
imparity1546783imparity
impark14287063impar_k
imparked17264863imparked
imparks15276663imparks
imparted13248063imparted
imparter12357543imparter
imparts11298533imparts
impaste11258003impaste
imped105117973im_ped
impel95711763im_pel
imphee13310343imphee
impiety1445083impiety
impled113812503impled
import102713753import
impost103011773impost
impregn1243403impregn
impresa1134753impresa
imprese1138143imprese
impress1137773impress
imprests1246313imprests
imprint11312553imprint
improv1344633improv
impure1038373impure_
impurer1136483impurer
impurest1245913impurest
impute1038033impute
inane52820343inane_
inaner62213533inaner
inanes62519803inanes
inanest72115363inanest
inapt73522693ina_pt
inarch1139163inarch
inarm7314423inar_m
inarmed10268673inarmed
inarms8410093inarms
inbred93010393inbred
inert53234373iner_t
infarct1249013infarct
infare9313083infare_
infares10313023infares
inkjet1737453inkjet
inlet53732403i_nlet
inmate82917353inmate_
inmates92715763inmates
insert64325253insert
inset54430863i_nset
intreat7416303intreat
inure54119053inure_
inured73114813inured
inures63318953inures
invert94120083invert
irade65618153irade_
irades74517393irades
irate55627983irate_
irater65218343irater
iratest7312483iratest
ire36943173i__re_
ired55131873i__red
ires45639283i__res
islet54527553i_slet
izar136616013izar__
izars145112933izar_s
karat96837593_karat
karst97228993_karst
kart86750803_kar_t
labret8320223labret
laree56036293_laree
lares54852633_lares
lazaret16411783lazaret
learnt64019253learnt
limpet103518633lim_pet
lyart85121883lyar_t
mabe85733343_mabe_
mabes96331533_mabes
mace87345783_mace_
maced108528693_maced
macer912126943_macer
maces97139963_maces
made75440233_made_
madre85720173_madre_
madres93718183_madres
mae57659103_ma_e_
maes66948393_ma_es
mage75739123_mage_
mages85036023_mages
magnet9320663_magnet
magot8326393_magot
maist75535673_maist
make105537883_make_
maker114127813_maker
makes115336853_makes
male66052293_male_
males75049793_males
mallet84433053_mallet
malt66254803_ma_lt
mamey125418833_mamey
mammet94319253_mammet
manat76039983_manat
mane65052013_mane_
maned86634093_maned
manes76648953_manes
mar57965943_mar__
mara67444563_mar_a
maras75443283_maras
marc87034623_mar_c
marcel103714853_marcel
march125622893_march
marcs95726623_marcs
marge85328333_marge
margent10316693_margent
marges94525713_marges
maria75032883_maria
mark105138053_mar_k
marka114620793_marka
marked133921623_marked
marker124420393_marker
markets133314033_markets
marks115933483_marks
marl66341613_mar_l
marled95523163_marled
marls75535163_marls
marly106925613_marly
marmot10318743_marmot
marred95421043_marred
marrer83716673_marrer
marry104821693_marry
mars66261863_mar_s
marse76231153_marse
marses84827113_marses
marsh105320853_marsh
marted94425213_marted
marten84518263_marten
martlet93419153_martlet
marts77442233_marts
marvel113712003_marvel
marvy135014033_marvy
maser75029973_maser
mast65959953_ma_st
mat58083933_ma__t
mate65154213_mate_
mated85537783_mated
mater74438863_mater
mates75251363_mates
matey107022663_matey
matres84522233_matres
matt65752653_ma_tt
matte75626843_matte
maumet103518883_maumet
maut65448443_ma_ut
maven104816893_maven
mawed115824743_mawed
maxed155821193_maxed
maxes145629533_maxes
mayed115522403_mayed
mayest114614793_mayest
mayst106622673_mayst
maze155434973_maze_
mazed175523873_mazed
mazer165722423_mazer
mazes165632173_mazes
meet65350553_m_eet
mere67244443_mere_
merer75126233_merer
meres75143573_meres
merest84725113_merest
merit7339183_merit
met56072433_m__et
midget103718443midget
millet84030743millet
minarets1048833minarets
minuet82621033minuet
mire66748223_mire_
mired85729223_mired
mires75640883_mires
mirex146816623_mirex
mismet103722373mismet
misset85028153misset
mitre75522423mitre_
mitred94414343mitred
mitres83922073mitres
more67154523_more_
morel75729093_morel
mores76249643_mores
mort66758833_mor_t
motet75641193_motet
mure65941333_mure_
mured85726703_mured
mures75937213_mures
murex145517173_murex
nares55544153_nares
neared75119803neared
nearer64618893nearer
nearest73415843nearest
oared65030653_oared
ombre94111793ombre_
ombres103911133ombres
omelet8317073omelet
palet74650803_palet
pare66760843_pare_
pared86946763_pared
parent83230423_parent
pareo74632603_pareo
parer75839903_parer
pares77164483_pares
pareu74928743_pareu
parget94529393_parget
part65967463_par_t
peart76440753pear_t
placet103923673placet
planet84228353planet
pomfret1446993pomfret
quare143920543quare_
quart144027853quar_t
quarte154115323quarte
quartet162814893quartet
ramet75743143_ramet
ramjet15311543ramjet
rare45348433_rare_
rared65738323_rared
rarer54731703_rarer
rares55247443_rares
rarest65725483_rarest
reared75930013reared
rearer64928913rearer
regret73723533regret
remarket142111033remarket
ret35982833___ret
roared75015393roared
roarer63914333roarer
samlet84126563samlet
saree55044663_saree
scare75334463scare_
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarlet91516943scarlet
scart76139773scar_t
seared75232843seared
searer65432023searer
searest73322023searest
secret8325063secret
share86437083share_
shared105829063shared
sharer95025483sharer
shares95236413shares
simar74920813simar__
simars84916933simar_s
smalt74729333sma_lt
smarm95517603smar_m
smarms105712533smarms
smarmy13629353smarmy
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartest10310183smartest
smarts86218003smarts
smarty115013793smarty
smaze165012933smaze_
smazes174311663smazes
smeared104510623smeared
smearer94110403smearer
snare54429983snare_
snared74824553snared
snarer64620843snarer
snares65329033snares
soared74324293soared
soarer64522243soarer
spare75135563spare_
spared95427483spared
sparer84524963sparer
spares84834553spares
sparest94616423sparest
stare54440263stare_
stared75429873stared
starer64027363starer
stares66038753stares
starets73515923starets
starlet71620123starlet
start55642313star_t
sware85828213sware_
swart86234643swar_t
tabaret92717313tabaret
tacet75840023_tacet
tare45957623_tare_
tared69340053_tared
tares57456563_tares
target75028903_target
tarot55943933_tarot
tart47566183_tar_t
teared75722153teared
tearer64822903tearer
terret63425623terret
timarau975843timarau
timbre10328623timbre_
timbrel11306553timbrel
timbres11249333timbres
tret46653533__tret
turret63121853turret
upmarket1644663upmarket
urare56322553urare_
urares64519093urares
valet84337873_valet
varlet9423503_varlet
vilayet1348533vilayet
ware76254723_ware_
wared96339873_wared
wares88250583_wares
wart77866083_war_t
wearer94319403wearer
yare75636943_yare_
yarer84321573_yarer
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 Filter1786911127160.1561145455.1
2DLD Change Limit1127164706.45317467.2
3Display Results4704700.1403357.1
 (SQL Overall)1786914706.74926476.7
 
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.