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

197 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
immesh133411(None) 
inmesh1134861inmesh
dimmest1249252dimmest
enmesh1134892enmesh
gimmes113010902gimmes_
immense1135292immense
immerse1145792immerse
immeshed1643432immeshed
immeshes1543932immeshes
immies102412442immies_
impish13499192impish
mesh96823002__mesh
mimes95732022mimes_
unmesh1145792unmesh
acmes96020653acmes_
afresh1255503afresh
aimless93610813aimless
almeh106214553alme_h
almehs11619493almehs
almes75126543almes_
ambush1336113ambush
amies76837693amies_
ammos94815823ammos_
biomes103815253biomes_
bummest13298623bummest
cames97047313cames_
comes97246993comes_
cometh134811683cometh
creesh11328333creesh
cymes1210118923cymes_
dames85435853dames_
demes86032693demes_
dimes85833043dimes_
dimmed124110323dimme_d
dimmer114112613dimme_r
dimmers123811563dimmers
dimness1038843dimness
dismes95617673dismes_
domes85735563domes_
emdash12244113emdash
emes65434663_emes_
emmer94314463emme_r
emmers104013223emmers
emmet94221383emme_t
emmets10349153emmets
emmys12446023emmys_
fames105735923fames_
famish14311843famish
femes105626223femes_
femmes135410213femmes_
firmest1239273firmest
flesh115013743_flesh
fresh115012203_fresh
fumes105224703fumes_
games86238553games_
gamest94919933gamest
gimme102411343gimme__
gimmies123010113gimmies_
grimmest13286293grimmest
hames106138703hames_
hemes105031083hemes_
homes106938813homes_
iambs95815063iambs_
ices66129643i_ces_
iciest82914743iciest
ides57734233i_des_
idles66720123idles_
idlest74014863idlest
illest63615723illest
images91411463images_
imams91511113imams_
imbed105013653imbe_d
imbeds11456743imbeds
imbues1037983imbues_
imides94515343imides_
imids86015143imids_
imines84918353imines_
immane1038883immane
immenser1244173immenser
immerge1244703immerge
immersed1344833immersed
immerses1235953immerses
immeshing17103463immeshing
immix1635033imm_ix
immixes1835073immixes_
immodest1344543immodest
immune1035433immune
immunes1136083immunes_
immure1036033immure
immures1136713immures_
immy114611833imm__y
impeach1644273impeach
imped105117983impe_d
impede11469623impede
impel95711773impe_l
impels10389523impels
impend11478793impend
impis96213853impis_
impose103113053impose
impost103011783impost
impresa1134753impresa
imprese1138143imprese
impress1137773impress
imprest11310203imprest
imps86221123i_mps_
incest82918743incest
infest93315433infest
ingest73119003ingest
inmeshed1444483inmeshed
inmeshes1345613inmeshes
inmost8411363inmost
inrush936513inrush
invest93014843invest
ires45639283i_res_
isles54220563isles_
isms66213473ism_s_
items7499613items_
ivies84215763ivies_
jimmies18328783jimmies_
jimpest18297553jimpest
kames115024693kames_
kirmess13234313kirmess
lamedh12476363lamedh
lames75445543lames_
lamest84722763lamest
limes75636503limes_
limiest93716103limiest
limmer104314793limme_r
limmers113413083limmers
limpest113712313limpest
maes66948403_maes_
marsh105320853_marsh
mash96039403__mash
memes94927703memes_
mems85931503_mems_
mensh105413563_mensh
mesa67025483__mesa
meshy135612783__meshy
mess65932433__mess
meth95827843__meth
mikes115129893mikes_
miles74645073miles_
mime85736403mime__
mimed105622733mime_d
mimeo96018683mime_o
mimeos104511543mimeos
mimer94825763mime_r
mimers105520183mimers
mimeses1139073mimeses
mimesis1137323mimesis
mimosa1036363mimosa
mines75651953mines_
minish115216303minish
mires75640883mires_
mises74740563mises_
mites75141803mites_
mixes147224403mixes_
momes95134473momes_
mosh95227603__mosh
mush94929123__mush
names74833363names_
nimmed11368573nimme_d
nomes74933123nomes_
pomes94833933pomes_
primmest14226693primmest
rammish1437563rammish
resh76523453__resh
rimes75634543rimes_
rimiest93215853rimiest
rimless9369363rimless
rimmed114812303rimme_d
rimmer103516033rimme_r
rimmers113812883rimmers
rummest11279833rummest
samech13277033samech
samekh15355133samekh
semes75731583semes_
sheesh1237813sheesh
siamese936503siamese
simmer104115353simme_r
simmers113314613simmers
slimmest1235903slimmest
smash104814433_smash
smoosh11236733smoosh
smush104410583_smush
sneesh945893sneesh
tames75242013tames_
tamest85721293tamest
thresh12276863thresh
times75630823times_
tomes76037383tomes_
trimmest12227023trimmest
tsimmes1133673tsimmes_
tzimmes2033063tzimmes_
wames106432803wames_
wimpish1765693wimpish
zymes1924712943zymes_

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.390458182.1
2DLD Change Limit1127161975.55020309.2
3Display Results1971970.0603283.3
 (SQL Overall)1786911976.00029781.8
 
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.