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

156 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
opens7611855(None) 
copens106119961copens
omens75618961omens
open66427001open_
opes65942611ope_s
ovens86217451ovens
pens65649641_pens
amens75624842amens
apers76629132apers
apes66047432ape_s
arpens84814822arpens
aspens85013352aspens
avens86419332avens
bens65945702_bens
brens75823362brens
codens94821012codens
copen94826432copen_
copers104629842copers
copes97747102cope_s
covens114919262covens
cozens176314922cozens
dens55945072_dens
dopers95522482dopers
dopes84935042dope_s
dovens104413902dovens
doyens104810222doyens
dozens164612462dozens
ens37245922__ens
epees75219832epees
evens84817102evens
fens76139762_fens
gens55740072_gens
glens66519852glens
hens75642572_hens
hopers114222972hopers
hopes105835642hope_s
keens95721182keens
kens85435232_kens
kopeks1134602kopeks
lens46146492_lens
liens56525502liens
lodens74315062lodens
lopers84424142lopers
lopes76437342lope_s
miens76118302miens
mopeds11499662mopeds
mopers104220372mopers
mopes95134982mope_s
obes66036832obe_s
obeys107010642obeys
oceans81211002oceans
odeons739022odeons
odes57243242ode_s
oes35866192o_e_s
ogees65119142ogees
okehs12477462okehs
okes84936342oke_s
oleins6313522oleins
oleos55419682oleos
oles46453472ole_s
omen66828182omen_
omers76923192omers
ones46146532one_s
ons36148512o__ns
opahs105411982opahs
opals75718352opals
ope56845242ope__
oped76230152ope_d
opened94311862opened
opener83910992opener
openers9339492openers
openest9312912openest
openly1137122openly
opera7313572opera
operas8312452operas
operons91411742operons
opine77422462opine
opines84820702opines
oping86322412oping
ops56641252op__s
opsins8411712opsins
opts68124742op_ts
opus66420592op_us
ores46056682ore_s
orpins83614162orpins
oses46641512ose_s
oven76624142oven_
overs85224792overs
owes75137102owe_s
owns76819582o_wns
oxen116218592oxen_
oxes116530722oxe_s
oyers87620882oyers
oyes74940132oye_s
pans65855732_pans
peans75437642_peans
peas65755062_peas
pecs84634102_pecs
peds75835242_peds
peens76428192peens
pees65257372_pees
pegs75531762_pegs
pehs95625762_pehs
peins76128062_peins
pen56558842_pen_
pend75934532_pend
pends85527192_pends
penes75839222_penes
penis75129322_penis
pent66559072_pent
peons75327182_peons
peps85134512_peps
pes57259782_pe_s
pets66248332_pets
pews95731532_pews
pins65558452_pins
poems95715552poems
poets76024442poets
pones74547042pones
pons65850602_pons
poons75430972poons
popes95933812pope_s
porns75527342porns
puns66641482_puns
reopens939372reopens
ripens85012172ripens
ropers84325902ropers
ropes75940062rope_s
rouens64814442rouens
rowens94515302rowens
sowens93613152sowens
spans74528732spans
speans85417142speans
specs96916672specs
spend85619332spend
spends94714472spends
spense83912432spense
spent75532832spent
spews105015922spews
spins75327982spins
teens56227482teens
tens45647412_tens
thens85921832thens
tokens104711562tokens
topees85519702topees
topers85025322topers
topes76941762tope_s
unpens82511012unpens
upend85011042upend
upends9438762upends
weens85224052weens
wens76337932_wens
whens114618762whens
wovens12449832wovens
wrens85016242wrens
yens75832262_yens

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.296603685.8
2DLD Change Limit538001561.56334421.0
3Display Results1561560.0305200.0
 (SQL Overall)1786911561.88994595.6
 
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.