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

291 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
lochan113909(None) 
lochans1248831lochans
clachan1437182clachan
cochin131313202cochin
lichen114012742lichen
loan47436452lo__an
loca65527682loc_a_
local74820272loc_al
loch95527132loch__
lochia1158312lochia
lochial1257082lochial
lochs106715512loch_s
logan68123282lo_gan
longan75612362longan
loran55925092lo_ran
mocha1249922mocha_
mochas13310652mochas
ocean71212962_ocean
octan71313482_octan
pechan13511542pechan
socman1039812socman
afghan1333873afghan
aloha8513613alo_ha_
alohas9411703alo_has
archean1269123archean
archon11311753archon
ashcan1135843ashcan
barchan1469133barchan
boche124216953boch_e
boches134618523boches
bodhran1343943bodhran
bogan87519003bo_gan
bowman13129853bowman
brechan1437223brechan
can57760133__c_an
chad105525503__chad
chai95929903__chai
chain105723673__chain
cham115532313__cham
chang115418563__chang
chant105932693__chant
chao95727313__chao
chap114928493__chap
char95132153__char
chat95546133__chat
chaw126224633__chaw
chay124924873__chay
chin96934743__chin
chon96627793__chon
clachans1546413clachans
clan65633923__clan
clochard1644293clochard
cloche134312373cloch_e
cloches144113713cloches
coachman1744983coachman
coca88030643coc_a_
cocain101315013cocain
cocas95926573coc_as
coccal9310223coccal
cochair1446313cochair
cochins141413093cochins
cocoa98517883cocoa_
cocoas104915743cocoas
cocoon10312263cocoon
concha134213283concha_
conchae143911643conchae
conchal144211583conchal
conchas144013313conchas
corban10314693corban
cotan71521783co_tan
couchant1549053couchant
cowhand1665933cowhand
cowman13910373cowman
cyan96419623__cyan
dacha114812573dacha_
dachas124113253dachas
dockhand1953393dockhand
dolman95312403dolman
enchain1248853enchain
enchant12313103enchant
eolian6312593eolian
eonian6311833eonian
epochal1445243epochal
eschar1136523eschar
etchant1249813etchant
eulachan1353023eulachan
focal104917673foc_al
foehn11236323foeh_n
foeman11311233foeman
fohn106116553fo_h_n
glochid1445263glochid
glucan936183gluc_an
glycan1234903glyc_an
goban84414073go_ban
gorhen1038893gorhen
gossan747233gossan
gotcha1234633gotcha_
gotchas1334613gotchas
gowan95415743go_wan
hogan97817703ho_gan
honan85319773ho_nan
john145512903jo_h_n
jordan1468063jordan
khan115819143__khan
koan85425033ko__an
kuchen1536653kuchen
laches116528343laches
lactam10310943lactam
lactean956473lactean
lacuna8118123lacuna
lagan66520343l_agan
lahar83114263l_ahar
lallan63414173lallan
larchen12479623larchen
lauan55216793l_auan
lawman11289053lawman
layman113511303layman
lean46345243l__ean
lech96825443lech__
leched123716003leched
lecher113415853lecher
leches115421313leches
leching134613653leching
lechwe1435113lechwe
lectin82515013lectin
legman949653legman
leman75622603l_eman
lethal939803lethal
lethean1037093lethean
lich96230843lich__
lichee114017973lichee
lichens123510683lichens
liches114724293liches
lichi104412953lich_i
lichis115212593lichis
licht104723493lich_t
lichts113712383lichts
ligan67920283l_igan
lignan75510323lignan
liman75921603l_iman
loach105116363loach__
loaches123613983loaches
load56730603lo__ad
loaf76734903lo__af
loam65630483lo__am
loans56026463lo__ans
lobar7313013lo_bar
locale83915653locale
locals83714503locals
locate83919843locate
loci66126283loc__i
lock106134363loc__k
lockage1436613lockage
locked134921663locked
locker124019423locker
locket123922473locket
locking143718153locking
lockjaw2341823lockjaw
lockram1544913lockram
locks115126923loc_ks
lockup1434763lockup
loco67030743loc__o
locoed94312193locoed
locoes85516583locoes
locoing102810973locoing
locos75822603loc_os
locular938953locular
locule83412033locule
loculi8288253loculi
locum94812173loc_um
locums10478303locums
locus74819993loc_us
locust85312343locust
loden66621143lo_den
logans76319063lo_gans
logia68116603logia_
logician1145223logician
login66025003lo_gin
logion76013723logion
logjam1635363logjam
logon615922313lo_gon
logway1335913logway
loin46838723lo__in
lomein8410203lomein
longans84510813longans
longhand1344493longhand
loofa85912813loofa_
loofah12375813loofah
loofas9429833loofas
loon47344793lo__on
loosen66615963loosen
loquat1558283loquat
loral55927823lo_ral
lorans65117603lo_rans
loreal63814313loreal
lorn46435253lo__rn
lota47233503lo_ta_
lotah85315853lo_tah
lotahs9479873lotahs
lotas55926303lo_tas
loth76132133loth__
lotion65716523lotion
louche115212663louch_e
louden73711793louden
louma76213633louma_
loumas84812333loumas
loupen84510293loupen
lovat8321043lo_vat
lowland1134693lowland
lown76929293lo__wn
loyal84513483lo_yal
lucern846103lucern
lungan74710213lungan
lurdan738363lurdan
lycea10418943lycea_
lych126015763lych__
lychee143710893lychee
lyches144213613lyches
lycra10317973lycra_
lycras11287243lycras
lyncean1292923lyncean
moan65832013mo__an
morgan9311373morgan
moshav1446053moshav
nachas114914193nachas
nonfan948293nonfan
nonman8412363nonman
nucha10229793nucha_
nuchae11218513nuchae
nuchal11218873nuchal
oca56731733_oc_a_
ocas66729633_oc_as
oceans81211003_oceans
ocher104516103_ocher
ochone11311293_ochone
ochre103411593_ochre
ochry13346933_ochry
octad81510653_octad
octal71214723_octal
octane81411633_octane
octans81411143_octans
octant81216553_octant
ogham1138253_ogham
oolachan13133353oolachan
organ6915393_organ
orphan1137733orphan
pacha126518063pacha_
pachas135017143pachas
pecan91919033pec_an
pechans14810503pechans
plowman1444933plowman
pochard1537363pochard
potman102813573potman
prochain1548483prochain
richen113812513richen
roan47234203ro__an
rochet115423003rochet
rodman949713rodman
roman75424823ro_man
rowan85418733ro_wan
scan65530453_sc_an
schav1338313_schav
siccan1037593siccan
slogan7539223slo_gan
soca66330053soc_a_
socas74026183soc_as
social8813333social
sockman1535663sockman
socmen1039193socmen
solan55328153so_lan
soldan73511853soldan
soman75024903so_man
soudan73210353soudan
sovran937153sovran
than76128773__than
tocher114014913tocher
tocsin8311003tocsin
tolan55124013to_lan
toman75724053to_man
torchon1237363torchon
toucan838193toucan
trochal1288243trochal
trochar1257063trochar
tuchun1145443tuchun
unchain1238943unchain
urchin1138743urchin
vocab12409973voc_ab
vocal104715643voc_al
wiccan1335033wiccan
woman105818003wo_man
zechin20137703zechin

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.1401276364.3
2DLD Change Limit1127162916.20318171.2
3Display Results2912910.0933129.0
 (SQL Overall)1786912916.43627764.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.