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

240 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
oyer7592765(None) 
coyer105222841coyer
dyer85522111dyer
eyer76127281eyer
foyer116416551foyer
omer67028391omer
over77227341over
oyers87620881oyers
oyes74940131oyes
oyez166020351oyez
toyer84521551toyer
tyer75323391tyer
ager55935842ager
aper66336232aper
aver75931882aver
aye67151762aye_
ayes76543512ayes
beer65635992beer
bier65531822bier
boner75133082boner
borer75131272borer
bower107328182bower
bowyer14368922bowyer
boxer145016522boxer
boyar106013762boyar
buyer105013092buyer
bye86134592bye_
byes95230532byes
byre95023852byre
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cover105430772cover
cower104531772cower
coyed114623802coyed
cyber124910382cyber
cyder114611132cyder
deer56739022deer
doer57734702doer
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
doyen95014412doyen
dozer158419272dozer
dryer95111462dryer
dye75334842dye_
dyed96720762dyed
dyers96617132dyers
dyes85331892dyes
eger55923562eger
er28345142__er
ever77027692ever
ewer77523982ewer
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyers86521332eyers
eyes75837882eyes
eyre75525252eyre
fer66646122_fer
feyer115014522feyer
flyer114916252flyer
foyers125413132foyers
fryer115913432fryer
gayer94519192gayer
goer56827102goer
gofer94814282gofer
gomer85220652gomer
goner66025152goner
gyre84722762gyre
hayer114620242hayer
her66547812_her
hoer76533982hoer
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
hyper135213902hyper
jeer115426462jeer
joker165715892joker
joyed164811832joyed
kier86526802kier
kyar116916842kyar
kye107327272kye_
kyes115124932kyes
layer84626472layer
leer46239352leer
lier45942462lier
loner55431032loner
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
lye66533412lye_
lyes75530832lyes
lyre75623792lyre
moper94925922moper
mover104220862mover
mower104523452mower
noter55025642noter
oar37057952o_ar
oater55433732oater
obe56638642obe_
obes66036832obes
obey96521302obey
obeyer1135892obeyer
ocher104516102ocher
ocker113915752ocker
odder74515392odder
ode47446582ode_
odea56224572odea
odes57243242odes
odor55718092odor
oe28473062o_e_
oes35866192o_es
offer114311382offer
ofter84116872ofter
ogee57629882ogee
ogler65917442ogler
ogre56320742ogre
ohed87825182ohed
oiler54628282oiler
oke75839482oke_
okeh114615322okeh
okes84936342okes
older65121172older
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omber95316432omber
omen66828182omen
omers76923192omers
one37050912one_
onery8414112onery
ones46146532ones
ope56845242ope_
oped76230152oped
open66427002open
opera7313572opera
opes65942612opes
or27354732o__r
order65019362order
ore36661832ore_
ores46056682ores
ormer75218372ormer
osar46820952osar
ose38147342ose_
oses46641512oses
osier53518012osier
other84219102other
otter54423972otter
our36042892o_ur
outer55633302outer
oven76624142oven
overs85224792overs
overt85630722overt
owe67041032owe_
owed86833872owed
owes75137102owes
owner84613312owner
oxen116218592oxen
oxes116530722oxes
oxter123414092oxter
oy58950132oy__
oyster94111702oyster
payer105125722payer
peer66238352peer
per56353092_per
pier66035292pier
plyer106214332plyer
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
pryer104415312pryer
pye86432502pye_
pyes95528992pyes
pyre94925552pyre
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
ruer46127562ruer
rye66032542rye_
ryes75529352ryes
sayer84926552sayer
seer45547042seer
ser36752402_ser
shyer114714782shyer
slyer85515122slyer
sober74822402sober
sorer56236572sorer
sower85229312sower
suer45334032suer
tier44936142tier
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyed96019802toyed
toyers95516332toyers
tuyer85414292tuyer
twyer11558522twyer
tye65837442tye_
tyee75131422tyee
tyers86220052tyers
tyes76433372tyes
tyre75428252tyre
user45023002user
veer76229572veer
vier75428152vier
vomer105517382vomer
voter85121052voter
vower115220792vower
voyeur1232862voyeur
weer75535092weer
wooer84316692wooer
wryer11489302wryer
wye96331972wye_
wyes105727502wyes
yar67253832_yar
ye57650062_ye_
yea66445752_yea
year76534252_year
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yerk116222082_yerk
yes66250612_yes
yet66960692_yet
yew96436292_yew
yore76335942yore
your78623432your
zoner144520342zoner

Search took 4 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.1701051123.5
2DLD Change Limit298722402.00014936.0
3Display Results2402400.1102181.8
 (SQL Overall)1786912402.28078373.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.