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

185 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
user4502300(None) 
muser76024121muser
ser36752401_ser
suer45334031suer
use36835161use_
used55722821used
users55817571users
uses44931111uses
usher84517761usher
abuser85413682abuser
ager55935842ager
amuser84712622amuser
aper66336232aper
asea46327182asea
asker96418782asker
asper75520432asper
aster55434892aster
auger64922472auger
aver75931882aver
baser74828922baser
beer65635992beer
bier65531822bier
bused85624492bused
buses75936012buses
busher114922202busher
busier85219722busier
busker125517832busker
buster84726492buster
buyer105013092buyer
causer84117782causer
cuber95222532cuber
curer75030752curer
curser84721472curser
cusec94614902cusec
cusser86016092cusser
cuter74728222cuter
deer56739022deer
doer57734702doer
doser66228562doser
douser75621632douser
duper85519002duper
duster74919722duster
dyer85522112dyer
eger55923562eger
er28345142__er
eses45336102eses
esker94412982esker
ester54727712ester
ever77027692ever
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
fumer105918232fumer
fuse76429992fuse_
fused94820442fused
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fusser94813772fusser
goer56827102goer
gusher104115772gusher
her66547812_her
hoer76533982hoer
hoser811529762hoser
houser95322282houser
huger94914872huger
husker134212702husker
jeer115426462jeer
juster134617012juster
kier86526802kier
laser54633322laser
leer46239352leer
lier45942462lier
loser54728672loser
luger65322082luger
lurer54625312lurer
lusher93818762lusher
luster64023672luster
maser75029972maser
miser75430402miser
mouser85822442mouser
muse67136032muse_
mused85524582mused
musers84719092musers
muses75134302muses
musher113820572musher
muster84724522muster
muter74525542muter
nuder66416832nuder
nurser64314502nurser
omer67028392omer
osar46820952osar
ose38147342ose_
oses46641512oses
osier53518012osier
ousel55222402ousel
ouster64223732ouster
outer55633302outer
over77227342over
oyer75927652oyer
pauser84415962pauser
peer66238352peer
per56353092_per
pier66035292pier
poser75128772poser
puler74826622puler
pulser84215192pulser
purer75127902purer
purser85020472purser
puses75532202puses
pusher114318282pusher
queer143712812queer
raser55633412raser
riser55431052riser
rouser65224082rouser
ruder65320542ruder
ruer46127562ruer
ruler54923342ruler
ruse45938932ruse_
ruses56136582ruses
rusher94019652rusher
sea36161292_sea
sear47353842_sear
sec55945322_sec
see35772262_see
seer45547042seer
seg45544882_seg
sei36048932_sei
sel38253322_sel
sen36058522_sen
sera46141392_sera
sere46153472_sere
serf76340112_serf
sers45746652_sers
set36681252_set
sew66247262_sew
sex107043222_sex
sir35746672_sir
suber74924502suber
sudser73511282sudser
sue35651462sue_
sued56537932sued
suers55128482suers
sues46247652sues
suet46754822suet
super74924482super
sure45447412sure
surer54833092surer
tier44936142tier
tsar47819802tsar
tuber75420682tuber
tuner56022682tuner
tusker104212192tusker
tusser64615832tusser
tuyer85414292tuyer
tyer75323392tyer
udder76314282udder
uke75727292uke_
ukes86122812ukes
ulcer7310752ulcer
ulster63712102ulster
umber94617582umber
under64624212under
unset54532432unset
unsew83912692unsew
unsex123512632unsex
upper93714262upper
upset73222592upset
urea46528052urea
urger64116472urger
us26937432us__
ushers94415532ushers
usnea539392usnea
usurer638102usurer
usurp7106902usurp
usury887622usury
ute35335882ute_
uteri51012982uteri
utes45930882utes
utter54218762utter
uvea74712652uvea
veer76229572veer
vier75428152vier
weer75535092weer
wiser85522802wiser

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 Filter178691298720.0762351197.4
2DLD Change Limit298721850.95331345.2
3Display Results1851850.0464021.7
 (SQL Overall)1786911851.075166224.2
 
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.