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

206 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
open6642700(None) 
copen94826431copen
omen66828181omen
ope56845241ope_
oped76230151oped
opens76118551opens
opes65942611opes
oven76624141oven
oxen116218591oxen
pen56558841_pen
amen66733152amen
ape57251182ape_
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
arpen74418042arpen
aspen75216092aspen
been65335782been
ben56554922_ben
bren65629562bren
coden86128542coden
cope86847382cope_
coped105036842coped
copens106119962copens
coper95336092coper
copes97747102copes
coven106925042coven
cozen165019702cozen
den47554342_den
dope76038892dope_
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
doven94718552doven
doyen95014412doyen
dozen155017472dozen
en28052392__en
epee64628502epee
even75222272even
eyen76223662eyen
fen66851352_fen
gaen57329602gaen
gen45950512_gen
gien56330022gien
glen56027202glen
haen76229452haen
hen67555272_hen
holpen11299412holpen
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopes105835642hopes
hosen85623882hosen
keen84830402keen
ken76343982_ken
kopek1037812kopek
lien45339802lien
loden66621142loden
lope65941922lope_
loped85128332loped
loper75129232loper
lopes76437342lopes
loupen84510292loupen
men59252852_men
mien65028362mien
mope86838042mope_
moped105424732moped
moper94925922moper
mopes95134982mopes
mopey124821822mopey
nomen75621622nomen
nope65934192nope_
oaken95814382oaken
oaten55222402oaten
obe56638642obe_
obes66036832obes
obey96521302obey
ocean71212962ocean
ode47446582ode_
odea56224572odea
odeon6411482odeon
odes57243242odes
oe28473062o_e_
oes35866192o_es
often84611412often
ogee57629882ogee
ohed87825182ohed
oke75839482oke_
okeh114615322okeh
okes84936342okes
olden65114852olden
ole37155212ole_
olea46532722olea
olein5316002olein
oleo46630482oleo
oles46453472oles
omens75618962omens
omer67028392omer
on28057182o__n
one37050912one_
ones46146532ones
op45850162op__
opah96218402opah
opal66923522opal
opened94311862opened
opener83910992opener
openly1137122openly
opera7313572opera
operon8811772operon
opine77422462opine
oping86322412oping
ops56641252op_s
opsin7613472opsin
opt57545542op_t
opted84914272opted
opts68124742opts
opus66420592opus
ore36661832ore_
ores46056682ores
orpin73415532orpin
ose38147342ose_
oses46641512oses
ovens86217452ovens
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
own66429702o_wn
owsen84210192owsen
oxes116530722oxes
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
pan58466452_pan
pe47649032_pe_
pea56657242_pea
pean66147172_pean
pec76744412_pec
ped66751522_ped
pee56066512_pee
peen65938082peen
peg65843062_peg
peh86740962_peh
pein65834942_pein
pend75934532_pend
pens65649642_pens
pent66559072_pent
peon65635242_peon
pep76447082_pep
per56353092_per
pes57259782_pes
pet56477302_pet
pew86442302_pew
pin57066722_pin
poem86225772poem
poet65552902poet
pone65747532pone
poon67341262poon
pope85535612pope_
popes95933812popes
porn65636022porn
pun58846512_pun
reopen8311572reopen
ripen75619262ripen
rope65542912rope_
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rouen54920902rouen
roven85521972roven
rowen84921152rowen
seen46943122seen
sen36058522_sen
span65234662span
spean74620512spean
spec85821972spec
sped76031492sped
spend85619332spend
spent75532832spent
spew95421872spew
spin66231302spin
spun66221462spun
teen45938202teen
ten35856112_ten
then78429692then
token95419312token
tope65946382tope_
toped85631312toped
topee76029952topee
toper75231022toper
topes76941762topes
unopen838912unopen
unpen72913572unpen
upend85011042upend
upon65817582upon
ween75835462ween
wen66249602_wen
when105723042when
woken124614972woken
women104619252women
woven115215172woven
wren78221682wren
yen66847382_yen

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.0632836365.1
2DLD Change Limit298722060.92032469.6
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.029173655.0
 
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.