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

250 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
outer5563330(None) 
couter84930201couter
cuter74728221cuter
muter74525541muter
oater55433731oater
ofter84116871ofter
otter54423971otter
ouster64223731ouster
outed65429061outed
outers64230161outers
outre53922191outre
oxter123414091oxter
pouter83923981pouter
router65025841router
souter64225921souter
touter63821031touter
acuter84412862acuter
after85719792after
alter54828502alter
apter76120202apter
aster55434892aster
auger64922472auger
auteur6107942auteur
biter75030032biter
boater84622092boater
bolter83920752bolter
bunter85020382bunter
buster84726492buster
bute66739672bute_
buteo75419892buteo
butes714535872butes
butler84220032butler
butter84724232butter
buyer105013092buyer
cater74840702cater
citer74827322citer
clouter93511682clouter
coater84329552coater
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
coulter94115592coulter
counter94220142counter
courter94516462courter
couters93827282couters
couther123914622couther
cuber95222532cuber
curer75030752curer
curter85320072curter
cute66440452cute_
cutes79438312cutes
cutey105819792cutey
cutler84718032cutler
cutter84520992cutter
dater65332312dater
deter65028042deter
doter65428622doter
dotter74419342dotter
doubter10298352doubter
dourer74215272dourer
douser75621632douser
duper85519002duper
duster74919722duster
eater54639842eater
enter54726382enter
ester54727712ester
flouter104311342flouter
fluter95316862fluter
footer94320762footer
foster94322222foster
fouler93614902fouler
fumer105918232fumer
gater64533642gater
goiter74116202goiter
gouger86014362gouger
goutier82612352goutier
grouter84412522grouter
gutter73817702gutter
hater85034752hater
hooter94123922hooter
hotter94720072hotter
houser95322282houser
huger94914872huger
hunter94817772hunter
hurter93915852hurter
inter55028492inter
jolter133513092jolter
jotter134315632jotter
jouster143311042jouster
juster134617012juster
jute115327892jute_
jutes125125132jutes
kiter95523212kiter
later54843922later
liter54736342liter
lofter94614722lofter
loiter64619172loiter
looter64222322looter
lotter64025602lotter
louder74414602louder
louted74920692louted
louver94110392louver
luger65322082luger
lurer54625312lurer
luster64023672luster
lute46341012lute_
lutea54819072lutea
luted64826142luted
lutes55836662lutes
mater74438862mater
meter75130322meter
miter75734792miter
molter84119422molter
mooter83921092mooter
moulter93812422moulter
mounter93713172mounter
mouser85822442mouser
mouther123812812mouther
muser76024122muser
muster84724522muster
mute65136872mute_
muted85023382muted
mutes75033782mutes
mutter84418882mutter
neuter63713792neuter
niter55028972niter
noter55025642noter
nuder66416832nuder
nutter63918052nutter
oaten55222402oaten
oaters65029782oaters
ocher104516102ocher
ocker113915752ocker
octet7324062octet
odder74515392odder
offer114311382offer
often84611412often
ogler65917442ogler
oiler54628282oiler
older65121172older
omber95316432omber
omer67028392o_mer
opted84914272opted
order65019362order
ormer75218372ormer
osier53518012osier
ostler63312192ostler
other84219102other
ottar54313992ottar
otters64021512otters
our36042892ou__r
ousel55222402ousel
ousted73720582ousted
ousters74122772ousters
out38072152out__
outbeg938732outbeg
outby10411532outby
outcry1137992outcry
outdo6312702outdo
outdoer849262outdoer
outearn7310682outearn
outeat62824532outeat
outgo6312092outgo
outhear10910602outhear
outled74020342outled
outlet63728682outlet
outlier72216142outlier
outs45746962out_s
outsee63121802outsee
outsert72819512outsert
outset64027452outset
outwar91011512outwar
outwear1097712outwear
ouzel144612322ouzel
over77227342o_ver
owner84613312owner
oxters134813272oxters
oyer75927652o_yer
oyster94111702oyster
pater74740722pater
peter74427592peter
porter84224412porter
poster84129172poster
potter83926982potter
poulter93712012poulter
pourer84516042pourer
pouted94021392pouted
pouters94221862pouters
poutier93215322poutier
powter114116032powter
puler74826622puler
punter84320022punter
purer75127902purer
putter83921442putter
queer143712812queer
quoter153510092quoter
rater54943282rater
rooter64926032rooter
roster64329082roster
rotter64325462rotter
rouser65224082rouser
rouster73517082rouster
route55132072route_
routed75624332routed
routers74822852routers
routes66129312routes
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
scouter93313322scouter
shouter103213072shouter
softer94015312softer
sorter64425082sorter
sourer63620212sourer
souters74422582souters
souther104116302souther
spouter94213222spouter
stouter74012052stouter
suber74924502suber
suer45334032su_er
suiter64121812suiter
super74924482super
surer54833092surer
sutler63718392sutler
tater54138612tater
tauter64318022tauter
titer55430612titer
tooter64420802tooter
toter55932132toter
totter65021462totter
tourer64115072tourer
touted74419742touted
touters74018332touters
tuber75420682tuber
tufter9319932tufter
tuner56022682tuner
tutee5423522tutee
tutor5712492tutor
tuyer85414292tuyer
user45023002_user
ute35335882_ute_
uteri51012982_uteri
utes45930882_utes
utter54218762utter
voter85121052voter
water84733312water
wuther124511612wuther
zoster153715852zoster

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 Limit538002501.69031834.3
3Display Results2502500.0604166.7
 (SQL Overall)1786912501.84396956.6
 
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.