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

191 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
ruers51501941(None) 
ruer46127561ruer_
rues46044481rue_s
rulers64317091rulers
suers55128481suers
agers65027852agers
apers76629132apers
arguers8489032arguers
armers85520272armers
augers73818702augers
aures55137092aures
avers85127312avers
beers75628392beers
biers76225222biers
briers85319732briers
buhrs104811242buhrs
burrs74925652burrs
burs65847422bu_rs
buyers114511002buyers
criers83918582criers
cruets85314952cruets
cruors838642cruors
cubers105318352cubers
cues65438982cue_s
curers84923192curers
cures75645432cures
currs75624392currs
curs65645542cu_rs
deers64930522deers
doers65225712doers
driers74516732driers
dryers10449272dryers
duels65619232duels
dues56045502due_s
duets65323882duets
dupers94615602dupers
dures65635922dures
durrs65519992durrs
dyers96617132dyers
egers65120372egers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
freers94717302freers
friers94718932friers
fryers125710972fryers
fuels87117352fuels
fumers113613382fumers
furs76735042fu_rs
gluers75011152gluers
goers65520252goers
gruels73910152gruels
grues65721962grue_s
guars65021052guars
guess64213362guess
hers75844872_hers
hoers85724922hoers
hues75235232hue_s
jeers124818132jeers
kiers95320092kiers
kues86426772kue_s
leers54828982leers
liers55130402liers
lues45943552lue_s
lugers74617022lugers
lurers64217492lurers
lures56138532lures
mures75937222mures
murrs75521302murrs
musers84719102musers
omers76923192omers
orders74315992orders
ormers84316142ormers
ours47237562ou_rs
outers64230172outers
overs85224792overs
oyers87620882oyers
peers75130272peers
piers75926332piers
priers84521192priers
pruners93710722pruners
pryers115012242pryers
pulers83820282pulers
purrs75320432purrs
purs65641042pu_rs
queers153510772queers
quern143610402quern
querns15307942querns
query174212082query
queys17398362queys
racers84725432racers
rakers104123572rakers
rapers84327182rapers
rares55247442rares
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
rears54739652rears
rebs65733562r_ebs
recs65734182r_ecs
reds56042862r_eds
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192r_ees
refers93921082refers
refs75732242r_efs
regs55436572r_egs
reis45343232r_eis
rems66237722r_ems
reps65937952r_eps
res35565042r_e_s
rets45352562r_ets
revers94529632revers
revs75027052r_evs
rheas84816952rheas
ricers84120992ricers
riders74123902riders
riels55121332riels
rimers84522552rimers
risers64624782risers
rivers94626542rivers
roars55622242roars
roes45954142roe_s
rogers74517912rogers
ropers84325902ropers
rouens64814442rouens
roues56039352roue_s
rousers75220142rousers
routers74822872routers
rovers95423522rovers
rowers94924572rowers
rubbers113913192rubbers
rubels84112992rubels
rubes74928412rubes
rubs66133492ru_bs
rubus76415062rubus
rucks114422052rucks
rudders93210652rudders
rudds74811702rudds
ruder65320542ruder_
rudery10419032rudery
rue35549262rue__
rued55729792rue_d
ruffs114516742ruffs
ruggers94612312ruggers
rugs56033682ru_gs
ruiners74213022ruiners
ruins55822032ruins
ruler54923342ruler_
rules55234252rules
rumens83611812rumens
rummers113513652rummers
rumors81110402rumors
rumps95922292rumps
rums64833472ru_ms
runes55530222runes
rungs611819402rungs
runners74212452runners
runs46438082ru_ns
runts55927632runts
rupees8312572rupees
ruses56136582ruses
rushers103816102rushers
rusks95816192rusks
rusts55026992rusts
ruths85714642ruths
ruts44541492ru_ts
ryes75529352rye_s
seers55136382seers
sers45746652_sers
subers85722642subers
suer45334032suer_
sues46247652sue_s
suets55126102suets
supers84622402supers
tiers55526522tiers
triers64321522triers
truer54916642truer_
trues54925322true_s
tubers85017032tubers
tuners64417342tuners
tuyers94612562tuyers
tyers86220052tyers
ureas55826012ureas
urgers73313622urgers
users55817572users
veers84521362veers
viers85621952viers

Search took 3 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.296603685.8
2DLD Change Limit538001911.67332157.8
3Display Results1911910.0464152.2
 (SQL Overall)1786911912.01588680.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.