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 “mioses” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
mioses8431885(None) 
meioses9310831meioses
miosis83615161miosis
mises74740561mi_ses
misses85130871misses
mitoses9312181mitoses
myoses114013841myoses
abioses9311492abioses
amitoses1039052amitoses
biases84618432biases
bigoses1039072bigoses
biomes103815252biomes
birses84717732birses
bises75435622bi_ses
broses86524402broses
choses115825132choses
closes85425592closes
coses76949492_coses
dieses75218692dieses
diodes83915782diodes
disses75225962disses
doses65938502_doses
eposes84418782eposes
eroses65327052eroses
gnoses76515162gnoses
gooses75723052gooses
hisses94719352hisses
hoises94823672hoises
hoses85443172_hoses
imposes113213682imposes
kiosks934382kiosks
kisses104217332kisses
looses67328242looses
loses56742012_loses
manses84225512manses
marses84827112marses
masses85028712masses
meiosis939022meiosis
menses84222452menses
messes84924342messes
miasms1097382miasms
miches134320732miches
midges103516482midges
midsts95510052midsts
mikes115129892mi_kes
miles74645072mi_les
milles84526562milles
mimes95732022mi_mes
mimeses1139072mimeses
mimosas1136752mimosas
minces104420802minces
mines75651952mi_nes
minkes124618782minkes
minuses93512702minuses
minxes154612982minxes
mires75640882mi_res
mise66043582mi_se_
miser75430402mi_ser
misers85025702mi_sers
misos76523292mi_sos
miss65339422mi_s_s
missed94423602missed
missel85216522missel
missels94614812missels
misset85028152misset
missets94516572missets
missies93423982missies
missis84417502missis
missus85312292missus
mists76633902mi_sts
misuses93216022misuses
mites75141802mi_tes
mitises9315542mitises
mitosis939632mitosis
mitres83922072mitres
mixes147224402mi_xes
modes85537412m_odes
moires8915632moires
mokes114631032m_okes
moles74747922m_oles
momes95134472m_omes
moose76327192moose_
mopes95134982m_opes
mores76249642m_ores
mosey105922872m_osey
moseys114711702m_oseys
moshes115222872m_oshes
mosks116117002m_osks
moss67641032m_os_s
mosses85527682mosses
mosts76028542m_osts
motes75944002m_otes
moues75732842m_oues
mouses85531422mouses
moves106128422m_oves
muses75134302m_uses
musses84624782musses
myases113711552myases
mycoses1437732mycoses
myiases1235492myiases
myopes13419962myopes
myosis114012562myosis
noises65021852noises
nooses65623642nooses
noses55435642_noses
oses46641512__oses
pisses84525082pisses
poises84226542poises
poses74642762_poses
proses84733472proses
ptoses83514672ptoses
pyoses114314302pyoses
riboses9310442riboses
rinses64720382rinses
rises55244042ri_ses
rooses65526232rooses
roses56445772_roses
semioses10611012semioses
sises55233832si_ses
sisses64520602sisses
trioses75015652trioses
viroses10310532viroses
vises84427772vi_ses
wises85633192wi_ses
wisses94619602wisses

Search took 3 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 Filter178691825510.593301333.9
2DLD Change Limit825511252.26636430.3
3Display Results1251250.0304166.7
 (SQL Overall)1786911252.88961852.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.