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

276 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
mimosa103636(None) 
mimosas1136751mimosas
limos75320812limos_
memos95719112memos_
midmost1246152midmost
milos75428012milos_
mimeos104511542mimeos_
mimes95732022mimes_
misos76523292misos_
mucosa10166272mucosa
rimose8310592rimose
samosa8510202samosa
aftosa996573aftosa
ahimsa1134783ahim_sa
aims67738183aim_s_
almost81014433almost
amigos94511213amigos_
ammos94815823ammos_
bigos85020013bigos_
bima86723833bim__a
bimas95521743bimas_
bimbos124610523bimbos_
bimodal1245663bimodal
bios66335323bi_os_
biota74516823bi_ota
biros75325133biros_
camisa103114323camisa
camos95927613camos_
citola838393citola
comose105016843comose
cymose13429653cymose
demos86022993demos_
didos76820813didos_
dimes85833043dimes_
dimout9414243dimout
dims75435023dim_s_
dinos65428063dinos_
eidola737683eidola
eidos65817753eidos_
femora1149583femora
fidos95819053fidos_
filos86125383filos_
filose96112503filose
finos86226953finos_
gimps105915203gimps_
giros65722653giros_
gismos957183gismos_
gizmos1844133gizmos_
hims95230973him_s_
homos105921783homos_
immesh1334113immesh
immoral1146783immoral
impose103113053impose
impost103011783impost
imps86221123_imps_
inmost8411363inmost
iota45127833_i_ota
ixora1236913_ixora
kibosh1534263kibosh
kilos95021473kilos_
kimono12105413kimono
kinos96626143kinos_
kiosk836233ki_osk
lidos65219883lidos_
lilos55821873lilos_
lima65734133lim__a
limas75627633limas_
limba95414983lim_ba
limbas105313203limbas
limbos104712143limbos_
limbs96118943limbs_
limes75636503limes_
limina83514503limina
limns75718393limns_
limo65529733limo__
limpa97014463lim_pa
limpas105513083limpas
limps95522673limps_
limpsy13516843limpsy
linos55631503linos_
lipoma1046753lipoma
maims96321793maim_s_
makos116518363makos_
mama86231593mam__a
mamas95930773mamas_
mamba116317523mam_ba
mambas125716243mambas
mambos125414493mambos_
mamma86317913mam_ma
mammas94616403mammas
manos74933623manos_
mariposa1243703mariposa
masa65034723__masa
massa75518923m_assa
mayos105521933mayos_
medusa936293medusa
memes94927703memes_
memo85924793memo__
memoir1037213memoir
memory1338803memory
mems85931503mem_s_
mensa75318673m_ensa
mesa67025483__mesa
mhos95517773m_hos_
miaou7513083miao_u
miaous8511693miaous
miaow1058353miao_w
miaows1145473miaows
miasm91211093mi_asm
miasma1097563miasma
mibs85330483mi_bs_
mica86428253mi__ca
micas96823053micas_
micks135525373micks_
micra96214973mi_cra
micros104115363micros_
mics87435153mi_cs_
midis85923413midis_
midmosts1343773midmosts
mids76541793mi_ds_
midst85922553mi_dst
miens76118303miens_
miffs134512883miffs_
miggs96311373miggs_
migs76935323mi_gs_
mikes115129893mikes_
mikra114610313mi_kra
mikvos1554023mikvos_
milds86422053milds_
miles74645073miles_
milia72719573mi_lia
milks115020583milks_
mills75435053mills_
milo65536103milo__
milord999573milord
milpa92111403mi_lpa
milpas101710273milpas
mils66045333mi_ls_
milts75430713milts_
mim76048423mim___
mimbar1297493mimbar
mime85736403mim__e
mimed105622733mim_ed
mimeo96018683mim_eo
mimeoed1235193mimeoed
mimer94825763mim_er
mimers105520183mimers
mimeses1139073mimeses
mimesis1137323mimesis
mimic111414323mim_ic
mimical1339233mimical
mimics1289363mimics
miming114317263miming
mina65136923mi__na
minas75434113minas_
minds85427123minds_
mines75651953mines_
minima105512653minima
minis75432993minis_
minish115216303minish
minks115829273minks_
minor74920063mino_r
minorca1145223minorca
minors85117103minors
mints76834043mints_
minus75223933minus_
mioses84318853mi_oses
miosis83615163mi_osis
mips85534083mi_ps_
mires75640883mires_
mirks115122143mirks_
mirs66940573mi_rs_
mirza16410443mi_rza
mirzas1738183mirzas
mis58162623mi__s_
mise66043583mi__se
mises74740563mises_
mishmosh18112913mishmosh
mismove1437083mismove
miso67229903mi__so
miss65339423mi__ss
missal84314903mi_ssal
missay114112143mi_ssay
missy105617563mi_ssy
mist66154533mi__st
mists76633903mists_
misuse83213643misuse
mites75141803mites_
mitis75425993mitis_
mitoses9312183mitoses
mitosis939633mitosis
mitts75523753mitts_
mixes147224403mixes_
mizuna1734303mizuna
moa57249183__mo_a
moas65545343__moas
mojos145314463mojos_
mola66035633__mola
momes95134473momes_
momism93410353momism
momma85111053mom_ma
mommas94110653mommas
moms86539483mom_s_
momus96116113momus_
monos75930863monos_
moola75117033m_oola
moos66051303m_oos_
moose76327193m_oose
mora66641273__mora
morose85116243morose
mos57067123__mos_
mosh95227603__mosh
mosk105622443__mosk
moss67641033__moss
most66554203__most
moxa136917743__moxa
mozos165516333mozos_
mucosae11155313mucosae
mucosal11155843mucosal
mucosas11146683mucosas
mucose10149313mucose
mumms85513153mumms_
mumps115619103mumps_
mums85732773mum_s_
mumus95517283mumus_
myoma1239273m_yoma
myomas1338303myomas
mysost1138263mysost
myxoma2043943myxoma
nims66226883nim_s_
nomos75919743nomos_
omasa749483_omasa
osmose8108003osmose
pilose84514243pilose
pima85428653pim__a
pimas94725103pimas_
pimps114616983pimps_
pisos76021063pisos_
pomos95321583pomos_
primos104514423primos_
ramona8412413ramona
ramose8314403ramose
remora8414593remora
ribose839893ribose
rimes75634543rimes_
rimous8311913rimous
rims65936303rim_s_
rioja1236303ri_oja
ripost83615003ripost
rugosa734563rugosa
samosas939293samosas
serosa6313023serosa
silos56029433silos_
sima64730783sim__a
simas75727553simas_
simony1137903simony
simoom1037503simoom
simoon858063simoon
simps94719763simps_
sims65737173sim_s_
sixmos1534813sixmos_
skimos12548803skimos_
sumos75720093sumos_
times75630823times_
tiros54524893tiros_
upmost1068193upmost
utmost878483utmost
vamose1159283vamose
vimina11339943vimina
vims95423313vim_s_
vinos84723073vinos_
viola85915543vi_ola
visa76323873vi__sa
wimps125213803wimps_
winos84625043winos_
zymosan2143803zymosan

Search took 6 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.376475242.0
2DLD Change Limit1127162765.43620735.1
3Display Results2762760.0763631.6
 (SQL Overall)1786912765.88830348.3
 
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.