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

194 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
mouse7713300(None) 
bouse75931851bouse
douse66329721douse
house89131421house
louse56131011louse
moose76327191moose
morse76032701morse
moue65835571mou_e
moues75732841moues
moused94423301moused
mouser85822441mouser
mouses85531421mouses
mousey115216191mousey
mousse84813031mousse
mousy106716941mousy
muse67136031m_use
rouse56634701rouse
souse56530771souse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arouse65019982arouse
blouse84714722blouse
boule74828042boule
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bowse105420632bowse
cause75225352cause
chouse116017562chouse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
cruse75726102cruse
dose56442432do_se
douce85518422douce
doused84821162doused
douser75621632douser
douses74928932douses
dowse96020812dowse
druse64817662druse
fosse86119462fosse
fuse76429992_fuse
goose65925902goose
gorse65926812gorse
gouge78220062gouge
grouse74315022grouse
hoise85224772hoise
horse86132652horse
hose76547242ho_se
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
joule124918202joule
joust125122292joust
loose56627682loose
lose45144582lo_se
louie55023512louie
loupe75319512loupe
loused74822912loused
louses66230282louses
lousy84617082lousy
lowse87219902lowse
manse75528222manse
marse76231152marse
masse75125292masse
mauve104013272mauve
mense75025632mense
meous76120062meous_
mise66043572m_ise
misuse83213642misuse
moas65545342moas_
mobs85737362mobs_
mocs85834902mocs_
mode75840302mo_de
modes85537412modes
mods77945052mods_
module93011032module
modus85417202modus_
mogs75439332mogs_
moire71017312moire
moist76033572moist
moke106234222mo_ke
mokes114631032mokes
mole66251832mo_le
moles74747922moles
mols65948572mols_
mome85239352mo_me
momes95134472momes
moms86539482moms_
momser104011412momser
momus96116112momus_
momuses1159262momuses
monde85723142monde
monie75631652monie
mons68152252mons_
monte75829772monte
moos66051302moos_
mope86838042mo_pe
mopes95134982mopes
mops85940132mops_
morae75831192morae
more67154522mo_re
mores76249642mores
morose85116242morose
mors65950062mors_
morsel85815892morsel
mos57067122mo_s_
mosey105922872mo_sey
mosh95227602mo_sh
mosk105622442mo_sk
moss67641032mo_ss
mossed94818892mossed
mosser84618272mosser
mosses85527682mosses
mosso74715182mosso
mossy105217062mossy
most66554202mo_st
moste75925082moste
mote67048082mo_te
motes75944002motes
mots66853162mots_
motte75526972motte
mouch124715802mouch
mould86015752mould
moult74728722moult
mound83918312mound
mount74128062mount
mourn77215012mourn
mousers95216442mousers
mousier93712462mousier
moussed10338912moussed
mousses94012702mousses
mouth105420292mouth
move96630722mo_ve
moves106128422moves
movie105319132movie
mows96340832mows_
moxie144018122moxie
mule65236972m_ule
mure65941332m_ure
mus55946752m_us_
mused85524582m_used
muser76024122m_user
muses75134302m_uses
mush94929122m_ush
musk104526192m_usk
muss64933762m_uss
must65145442m_ust
mute65136872m_ute
noise55723732noise
nonuse63212252nonuse
noose55624062noose
nose46739362no_se
nous46136982nous_
nouses64627162nouses
ose38147342_o_se
ousel55222402_ousel
oust46747442_oust
owse76321622_owse
pause75021832pause
poise75127892poise
pose66441732po_se
posse74722272posse
reuse56025362reuse
roose56127092roose
rose46148902ro_se
roue45941742rou_e
roues56039352roues
rouge65423442rouge
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
route55132072route
ruse45938932_ruse
scouse84113632scouse
sous46947212sous_
soused74822982soused
souses64229242souses
spouse84112512spouse
torse55833332torse
toused74122012toused
touses64229672touses
tousle64514652tousle
use36835162__use
worse86525262worse
yous76230652yous_

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001941.54634799.5
3Display Results1941940.0464217.4
 (SQL Overall)1786911941.685106048.1
 
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.