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 “orchil” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
orchil115865(None) 
archil11611571archil
orchid1289571orchid
orchils1277701orchils
orchis11710771orchis
archils12510532archils
orcein838182orcein
orchids1377212orchids
orcin72716572orc_in
orphic1368322orphic
trochil1258712trochil
urchin1138742urchin
arch98628443arch__
archaic1438823archaic
arched125717323arched
archer115016243archer
arches114822043arches
archine125817053archine
arching136216693arching
archival1645783archival
archive154610483archive
archly1437353archly
archon11311753archon
arctic10313513arctic
argil65116883ar_gil
aril45843023ar__il
arshin9312173arshin
botchily1864373botchily
boychik2143943boychik
brachia141910423brachia
brachial15219303brachial
brail75525553br_ail
brasil8713863brasil
brazil1779623brazil
broil74918223br_oil
ceil65725063__ceil
chi86228653__chi_
chia96026623__chia
chic115925203__chic
chid106626403__chid
chiel104918973__chiel
child114516223__child
chile105626893__chile
chili106218483__chili
chill105619873__chill
chin96934743__chin
chip116726423__chip
chis95933313__chis
chit96937463__chit
cochin131313203cochin
coil66439653__coil
conchal144211583conchal
conchie143312683conchie
corbeil11859213corbeil
drail65020973dr_ail
ervil8310303er_vil
frail85220213fr_ail
frazil1847223frazil
godchild1642273godchild
grail64622873gr_ail
hoochie1537803hoochie
ischia1136393ischia
ischial1246423ischial
itchily1574493itchily
lichi104412953lichi_
lichis115212593lichis
lochia1158313lochia
lochial1257083lochial
mochila1446523mochila
morphia1447483morphia
morphic1648693morphic
morphin1439003morphin
nihil8410283_nihil
nuchal11218873nuchal
ocher104516103o_cher
ochre103411593o_chre
ochry13346933o_chry
octal71214723o_ctal
octyl10136063o_ctyl
oculi72010793o_culi
ohia75719363o__hia
oil37452053o___il
orach105219233orach__
orache114013593orach_e
oraches124216473oraches
oral47638123or__al
orbit73622063or_bit
orc57034923orc___
orca65522773orc__a
orcas75918623orc_as
orceins937743orceins
orchard1346933orchard
orchises1338773orchises
orchitic1546293orchitic
orchitis1346423orchitis
orcinol944703orcinol
orcins83313433orcins
orcs67025433orc__s
ordain7810403ordain
ordeal779253ordeal
orectic1138823orectic
orgic8311823or_gic
oribi7311093oribi_
oribis838833oribis
oriel54920423or_iel
origin7311033origin
ornis54616773or_nis
orphan1137733orphan
orphical1546733orphical
orphism1446183orphism
orpin73415533or_pin
orris54516553or_ris
ortho8312293orth_o
ouch95724633ouch__
ouched124316933ouched
ouches114322183ouches
ouching134314903ouching
outchid1338723outchid
outhit92818473outhit
overchill1794213overchill
oxtail1337653oxtail
oxyphil2242373oxyphil
porch125918623porch__
porches143815673porches
prechill1546193prechill
rachial122012173rachial
rachis114017653rachis
rail46147763_r_ail
recoil84016723recoil
reoil55321183_reoil
rochet115423003rochet
roil46235293_r_oil
roshi8310753roshi_
roshis9311793roshis
schul102510413_schul
techie11511723techie
techily1537123techily
torch107420933torch__
torched133511353torched
torches123715433torches
torchier1337463torchier
torching142510083torching
torchon1237363torchon
torchy14549533torch_y
touchily1645233touchily
trail55126773tr_ail
trochal1288243trochal
trochili1376943trochili
trochils1388583trochils
unchic1338643unchic
uncoil8811853uncoil
upcoil10126193upcoil
uracil8311543uracil
urchins1238863urchins
wormil1138043wor_mil
worship1547833worship
worthily1745253worthily
zechin20137703zechin
zoril143916693zor__il

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161595.70319764.3
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.13929107.5
 
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.