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

199 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
orle4563046(None) 
ogle56325051ogle
ole37155211o_le
ore36661831or_e
orles55326211orles
role45851821role
able66340532able
ale36572342_ale
are37874572ar_e
argle65421562argle
arles56735742arles
arse46539272arse
axle116424602axle
bale66353842bale
bile66147182bile
birle75023632birle
bogle85821682bogle
bole66448692bole
bore66051332bor_e
borne77926792borne
boule74828042boule
brae65639112brae
bree67241262bree
brie65837902brie
carle74535702carle
coble94823172coble
cole66956112cole
core67263112cor_e
corse75036182corse
dale55643982dale
dele56843082dele
dole56550002dole
dore56353302dor_e
dree56638322dree
ere36352772er_e
erne46727432erne
farle86929242farle
file75446642file
force105324272force
fore78351472for_e
forge95126942forge
forme105225992forme
forte86131462forte
frae75330472frae
free75940182free
froe75329992froe
gale56347322gale
gore55744962gor_e
gorge76423892gorge
gorse65926812gorse
gree56641562gree
grue55825712grue
hale76052832hale
hole77553392hole
horde94623052horde
horse86132652horse
hoyle11314412hoyle
idle55423762idle
ire36943172ir_e
isle45121702isle
jole117233822jole
joule124918202joule
kale86533752kale
kore85834162kor_e
lore45850352lor_e
male66052302male
merle75824372merle
mile66352572mile
mole66251832mole
morae75831192morae
morale85220552morale
more67154522mor_e
morel75729092morel
morse76032702morse
mule65236972mule
noble74420992noble
obe56638642o_be
oboe66822942oboe
obole75917142obole
ode47446582o_de
odyle9349592odyle
oe28473062o__e
ogee57629882ogee
ogled75915962ogled
ogler65917442ogler
ogles65223182ogles
ogre56320742ogre
oil37452052oil_
oiled64429472oiled
oiler54628282oiler
oils46337972oils
oily77932252oily
oke75839482o_ke
old47033462o_ld
olea46532722o_lea
oleo46630482o_leo
oles46453472o_les
olla44821172olla
once65423082once
one37050912o_ne
only75319722only
oorie53026362oorie
ooze136420602ooze
ope56845242o_pe
or27354732or__
ora37250832or_a
oracle84313292oracle
orad56031692orad
oral47638122oral
orals55826482orals
orate55133302orate
orb55736862or_b
orbed85516192orbed
orbs66626252orbs
orby97519602orby
orc57034922or_c
orca65522772orca
orcs67025432orcs
order65019362order
ordo54622352ordo
ores46056682ores
orgy85218002orgy
oriel54920422oriel
oriole6814292oriole
orlon5415002orlon
orlop7410902orlop
ormer75218372ormer
orra46120722orra
ors35750112or_s
ort39465232or_t
orts46538332orts
oryx14510212oryx
orzo134516782orzo
ose38147342o_se
ourie54027302ourie
ovule839492ovule
owe67041032o_we
owl66228972owl_
owlet83324462owlet
owls76022932owls
owse76321622owse
pale66055012pale
parle75836162parle
pele65539552pele
pile65649692pile
pole65951302pole
pore66451262por_e
pree67044732pree
prole74527792prole
pule65040952pule
rale45050562rale
re26153742_r_e
ree37974072_ree
rile45650532rile
robe65335642robe
roble75223022roble
rode55844302rode
roe36861082_roe
roles56747982roles
rolf75134872rolf
roll46331652roll
rope65542912rope
rose46148902rose
rote46249022rote
roue45941742roue
rove75136982rove
rue35549262_rue
rule49938422rule
rye66032542_rye
sale44959702sale
socle7419572socle
sole46053672sole
sore47059532sor_e
sorel56231442sorel
tale46154162tale
tele45040872tele
tile45451442tile
toile54626492toile
tole46052902tole
tore47359322tor_e
torse55833332torse
torte55431702torte
tree47745812tree
true46725852true
tule45735872tule
urge54722422urge
vale74937342vale
vile76139802vile
voile84719722voile
vole75236982vole
wale74546432wale
wile75944372wile
wore77144672wor_e
world96915362world
worse86525262worse
wyle105519382wyle
yodle94515042yodle
yore76335942yor_e
yule75725142yule

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.280638182.1
2DLD Change Limit298721990.89033564.0
3Display Results1991990.0503980.0
 (SQL Overall)1786911991.220146468.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.