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

143 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
museums113456(None) 
museum1037701museum_
meseems1165602meseems
musers84719102muse_rs
muses75134302muse__s
amusers94610193amuse_rs
amuses85117943amuse__s
aureus65314883aureu_s
aurums849383au_rums
auteurs7137503auteurs
beseems1175913beseems
bunkums1544053bunkums
buses75936013buse__s
cesiums1136303cesiums
cundums1235183cundums
cuprums1334453cuprums
curiums1138503curiums
cuscus1038113cuscu_s
cusecs10509153cuse_cs
customs11348263customs
diseurs839403diseurs
dumdums1343043dumdums
durums948153du_rums
dustups1033913dustups
frustums1342993frustums
fusees95416403fuse_es
fusels94412453fuse_ls
fuses85628423fuse__s
fusuma1134503fus_uma
geums85414113__geums
inseams9307903inseams
jugums16104673ju_gums
lustrums1044663lustrums
lusus54813873lus_u_s
luteum837783luteum_
lyceums1442403lyceums
magnums1234683magnums
makeups1533603makeups
masers84623453mase_rs
masques18239363masques
masseurs1034923masseurs
mausoleums1451153mausoleums
mediums12308723mediums
mems85931503m__e_ms
miniums113910223miniums
misaims11310113misaims
miscues11312393miscues
miscuts1139183miscuts
misdeems13255653misdeems
miseats92815783miseats
misers85025703mise_rs
mises74740563mise__s
missus85312293missu_s
misterms123711353misterms
modems114610763mode_ms
moseys114711703mose_ys
mosques18256913mosques
mousers95216443mouse_rs
mouses85531423mouse__s
muclucs1343683muclucs
mucous104411653mucou_s
mucus94015743mu_cu_s
mudbugs1342853mudbugs
mueslis935493mueslis
mugfuls1344003mugfuls
muggurs11315103muggurs
mugwump1741213mugwump
mugwumps184813mugwumps
mukluks1242413mukluks
muktuks1242253muktuks
mules75034293mule__s
muletas937383muletas
muleys11409643mule_ys
mumms85513153mu__mms
mums85732773m___ums
mumus95517283mu_mu_s
muoniums1244723muoniums
mureins9310733mureins
mures75937213mure__s
murexes1636973murexes
murmurs1134523murmurs
muscats1138933muscats
muscids12187973muscids
muscles11310563muscles
muse67136033muse___
mused85524583muse__d
museful1245883museful
muser76024123muse__r
musette938433musette
musettes1037433musettes
mushers124016443mushers
mushes114124563mus_hes
musicks15297053musicks
musics103911783mus_ics
musings10389543musings
musjids17185713musjids
muskegs14285013muskegs
muskets13258643muskets
muskies133614673muskies
muskits13278563muskits
musks116119643mus__ks
muslins9312213muslins
musquash2241603musquash
muss64933763mus___s
mussels9419843mussels
musses84624783mus_ses
mustees94614923mustees
musters94522513musters
musths11589483mus_ths
musts75527443mus__ts
mutes75033783mute__s
mutisms11338453mutisms
mutuels935943mutuels
muumuus1141763muumuus
neums75414253__neums
odeums9367313_odeums
oleums8358783_oleums
ousels64815273ouse_ls
poseurs9378293poseurs
possums1145753possums
pseuds944793_pseuds
puses75532203puse__s
pushups1433653pushups
queues153510193qu_eues
quorums1843893quorums
rheums1135463_rheums
ruses56136583ruse__s
scums95017423__scums
seams75731663__seams
sebums10369813__sebums
sedums93910483__sedums
seems75525023__seems
serums83916303__serums
slums74623433__slums
stums75320083__stums
subgums1235893subgums
sums65837583__s_ums
tuneups933333tuneups
tussurs7356393tussurs
unseams9338913unseams
users55817573_use_rs
uses44931113_use__s
usques15126803_usques

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271436.70319995.1
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.90525878.5
 
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.