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 “orles” 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
orles5532621(None) 
arles56735741arles
ogles65223181ogles
oles46453471o_les
ores46056681or_es
orle45630461orle_
roles56747981roles
ables75935542ables
ales47067102_ales
ares45871022ar_es
argles75218482argles
arses55733872arses
axles125219472axles
bales76250082bales
biles75542142biles
birles84920642birles
bogles95020832bogles
boles75448602boles
bores76448252bor_es
boules84925972boules
braes75735052braes
brees75632552brees
bries74942152bries
carles85435082carles
cobles104622882cobles
coles76055062coles
cores76361852cor_es
corses84433462corses
corves115122522corves
cries75438402cries
dales66439742dales
deles65139252deles
doles67843752doles
dories75232362dories
drees65628522drees
dries64733672dries
ernes55224812ernes
erses55826802erses
farles96025782farles
files85441272files
folles93820472folles
forces114422132forces
fores85847102for_es
forges105024262forges
formes114623712formes
fortes95327182fortes
frees86131392frees
fries85535602fries
froes86126692froes
gales65442482gales
gores65740372gor_es
gorges85321892gorges
gorses74723292gorses
grees65132472grees
grues65721962grues
gules64831042gules
hales85449842hales
holes84748652holes
hordes104921632hordes
horses94729342horses
hoyles12315012hoyles
idles66720122idles
ires45639282ir_es
isles54220562isles
joles125230832joles
joules134116822joules
kales95730982kales
les35663072__les
lores55045402lor_es
lories64933042lories
males75049792males
merles85322762merles
miles74645072miles
moles74747922moles
morales93619402morales
morels84820012morels
mores76249642mor_es
mules75034292mules
nobles83319722nobles
oarless73913372oarless
oases55330982oases
oaves84925612oaves
obes66036832o_bes
oboes75717712oboes
oboles83815832oboles
odes57243242o_des
odyles10348562odyles
oes35866192o__es
ogees65119142ogees
ogle56325052ogle_
ogled75915962ogled
ogler65917442ogler
oglers74313182oglers
ogres65818632ogres
oiled64429472oiled
oiler54628282oiler
oilers64721192oilers
oils46337972oil_s
okes84936342o_kes
olds55926572o_lds
ole37155212o_le_
olea46532722o_lea
oleo46630482o_leo
oleos55419682o_leos
ollas54218282ollas
ones46146532o_nes
oodles73517182oodles
oozes145418712oozes
opes65942612o_pes
oracles93212422oracles
orals55826482orals
orates64328612orates
orbed85516192orbed
orbless937492orbless
orbs66626252or_bs
orcas75918622orcas
orcs67025432or_cs
order65019362order
orders74315992orders
ordos65216202ordos
ore36661832or_e_
orgies72316092orgies
oriel54920422oriel
oriels64914622oriels
orioles7412992orioles
orlon5415002orlon
orlons6411012orlons
orlop7410902orlop
orlops847302orlops
ormer75218372ormer
ormers84316142ormers
ornis54616772ornis
orris54516552orris
ors35750112or__s
orts46538332or_ts
oryxes1674522oryxes
orzos143311252orzos
oses46641512o_ses
ovules938222ovules
owes75137102o_wes
owlet83324462owlet
owlets93110392owlets
owls76022932owl_s
oxes116530722o_xes
oyes74940132o_yes
pales75753802pales
parles86334402parles
peles75738082peles
piles74742612piles
poles75351002poles
pores75849032por_es
prees75937172prees
pries74339532pries
proles84627202proles
pules74538812pules
rales54947492rales
rees45364192_rees
res35565042_r_es
riles55343642riles
robes75133302robes
robles85321692robles
rodes614039082rodes
roes45954132_roes
role45851822role_
rolfs84817122rolfs
rolls55326232rolls
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
rues46044482_rues
rules55234252rules
ryes75529352_ryes
sales56055592sales
socles8418452socles
soles55547922soles
sorels63921162sorels
sores55454282sor_es
tales55451372tales
teles54536002teles
tiles55542102tiles
toiles63923512toiles
toles55147132toles
tores55352672tor_es
tories65435882tories
torses64727952torses
tortes64826052tortes
trees55835762trees
tres46542902tr_es
tries55742812tries
trues54925322trues
tules54532792tules
urges64619912urges
vales85434262vales
voiles94616442voiles
voles86234042voles
wales86142832wales
wiles85437872wiles
worlds10568732worlds
worses95522952worses
wries85827742wries
wyles114615322wyles
yodles103714332yodles
yores85031322yor_es
yules84521582yules

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 Limit538002061.47036598.6
3Display Results2062060.0633269.8
 (SQL Overall)1786912061.626109896.1
 
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.