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

188 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
muser7602412(None) 
amuser84712621amuser
maser75029971maser
miser75430401miser
mouser85822441mouser
muse67136031muse_
mused85524581mused
musers84719091musers
muses75134301muses
musher113820571musher
muster84724521muster
muter74525541muter
user45023001_user
abuser85413682abuser
amuse75920832amuse_
amused94412512amused
amusers94610192amusers
amuses85117942amuses
auger64922472auger
baser74828922baser
bused85624492bused
buses75936012buses
busher114922202busher
busier85219722busier
busker125517832busker
buster84726492buster
buyer105013092buyer
causer84117782causer
cuber95222532cuber
curer75030752curer
curser84721472curser
cusec94614902cusec
cusser86016092cusser
cuter74728222cuter
doser66228562doser
douser75621632douser
duper85519002duper
duster74919722duster
fumer105918232fumer
fuse76429992fuse_
fused94820442fused
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fusser94813772fusser
gusher104115772gusher
hoser811529762hoser
houser95322282houser
huger94914872huger
husker134212702husker
juster134617012juster
laser54633322laser
loser54728672loser
luger65322082luger
lurer54625312lurer
lusher93818762lusher
luster64023672luster
macer912126942macer
maker114127812maker
masers84623452masers
masher114123202masher
masker124416102masker
master84831342master
mater74438862mater
mauger93813482mauger
mauler84416712mauler
mazer165722422mazer
merer75126232merer
meter75130322meter
miler75733062miler
mimer94825762mimer
miner76933542miner
mise66043582mise_
misers85025702misers
misery114113542misery
mises74740562mises
mister84728562mister
misuser93210442misuser
miter75734792miter
mixer145017642mixer
momser104011412momser
moper94925922moper
mosey105922872mosey
mosher114719792mosher
mosser84618272mosser
mouse77133002mouse_
moused94423302moused
mousers95216442mousers
mouses85531422mouses
mousey115216192mousey
mousier93712462mousier
mover104220862mover
mower104523452mower
mucker143816392mucker
mucor94011942mucor
mudder104413492mudder
mugger103914702mugger
mule65236972mule_
muled85824432muled
mules75034292mules
muley104819282muley
muller83820352muller
mummer93614542mummer
mumper123513522mumper
munster93710522munster
murder93613782murder
mure65941332mure_
mured85726702mured
mures75937212mures
murex145517172murex
murker123715242murker
murr65225132mu_rr
murre74821072murre
mus55946752mus__
musca9311762musca
museum1037702museum
mush94929122mus_h
mushed124420842mushed
mushers124016432mushers
mushes114124562mushes
mushier123813582mushier
mushy135316632mushy
music94316402music
musk104526192mus_k
muskeg13338182muskeg
musket122818202musket
muskier134312722muskier
musks116119642musks
musky144715292musky
muss64933762mus_s
mussed94418902mussed
mussel83412902mussel
musses84624782musses
mussier93314352mussier
mussy104117642mussy
must65145442mus_t
musted93321072musted
mustee83922102mustee
musters94522492musters
musth105314782musth
mustier94017952mustier
musts75527442musts
musty105620952musty
mute65136872mute_
muted85023382muted
mutes75033782mutes
mutter84418882mutter
nuder66416832nuder
nurser64314502nurser
ousel55222402ousel
ouster64223732ouster
outer55633302outer
pauser84415962pauser
poser75128772poser
puler74826622puler
pulser84215192pulser
purer75127902purer
purser85020472purser
puses75532202puses
pusher114318282pusher
queer143712812queer
raser55633412raser
riser55431052riser
rouser65224082rouser
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
ruse45938932ruse_
ruses56136582ruses
rusher94019652rusher
ser36752402__ser
suber74924502suber
sudser73511282sudser
suer45334032su_er
super74924482super
surer54833092surer
tuber75420682tuber
tuner56022682tuner
tusker104212192tusker
tusser64615832tusser
tuyer85414292tuyer
umber94617592umber
use36835162_use_
used55722822_used
users55817572_users
uses44931112_uses
usher84517762_usher
wiser85522802wiser

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 Filter178691538000.186960704.3
2DLD Change Limit538001885.5469700.7
3Display Results1881880.1561205.1
 (SQL Overall)1786911885.88830348.3
 
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.