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

152 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
coria7582830(None) 
ceria75125351ceria
cobia94117501cobia
curia74523761curia
noria55722181noria
scoria8513481scoria
agria65517142agria
aorta55922572aorta
aporia8315862aporia
aria46245422_aria
atria56022332atria
bora66141632bor_a
boric98024222boric
cardia9916372cardia
carina84325322carina
cerias83321972cerias
ceric94023092ceric
chia96026622c_hia
chorea115216082chorea
chorial124214142chorial
choric133515892choric
ciboria1147042ciboria
cilia73016762cilia
circa9311402circa
coala77521122coala
cobias104014972cobias
cobra95214402cobra
coca88030642co_ca
cocoa98517882cocoa
coda77029342co_da
codeia94112182codeia
coif96337902co_if
coil66439652co_il
coin66645352co_in
coir66327242co_ir
coirs75221052coirs
cola66541392co_la
colic95726172colic
colin76231692colin
colza165112982colza
coma87134852co_ma
comic114721812comic
comix163513192comix
comma114514792comma
conga85419872conga
coni65534802coni_
conic95329792conic
conin76232722conin
copra98115462copra
cor59960942cor__
coral76033452coral
corban10314692corban
corbie103618202corbie
corbina111911442corbina
corby125018532corby
cord76740922cor_d
cordial10312932cordial
cords86030622cords
core67263112cor_e
cored85044222cored
coremia11310362coremia
corer75538872corer
cores76361852cores
corf95941482cor_f
corgi8316082corgi
corgis9314402corgis
coring94433962coring
corium10315722corium
cork106635692cor_k
corks116028272corks
corky145221152corky
corm85735372cor_m
corms95626222corms
corn69945812cor_n
cornea84018922cornea
corns76034762corns
cornu75921322cornu
cornua85411902cornua
corny106023272corny
corona83817402corona
corps95927042corps
corral83616252corral
corrida1078492corrida
corrie83621212corrie
cors66656442cor_s
corsac10410172corsac
corse75036182corse
cortin82423142cortin
cortina91915962cortina
corvid12310472corvid
corvina12229492corvina
cory96941512cor_y
coryza2074572coryza
cosie74728262cosie
costa75523732costa
cotta75818572cotta
covin105621122covin
cowrie113814272cowrie
coxa136922962co_xa
cozie163519122cozie
crib86323572c_rib
cris66233432c_ris
crit65743712c_rit
curiae84518372curiae
curial84019152curial
curie74533032curie
curio74221202curio
dorsa64617282dorsa
feria85922712feria
folia83618932folia
fora75937392for_a
gloria71910542gloria
gonia64117532gonia
hora76136552hor_a
kora86431552kor_a
korai97018512korai
korma115913072korma
logia68116602logia
lorica8310442lorica
loris55329152loris
maria75032882maria
moira71012012moira
mora66641272mor_a
nori47133142nori_
norias65518182norias
noris54928272noris
obia67923102_obia
ocrea73311822ocrea
ohia75719362_ohia
oorie53026362oorie
ora37250832_or_a
orca65522772_orca
orra46120722_orra
podia8415282podia
ria36745502__ria
scoriae9310892scoriae
scotia8310782scotia
sora45746912sor_a
sori46039832sori_
sorta57125412sorta
stria55723202stria
thoria93012882thoria
tora47545992tor_a
tori47542152tori_
toric76529312toric
torii55521592torii
torta55925352torta
varia85824202varia
zoaria1548372zoaria
zori137722922zori_
zoril143916692zoril
zoris145320012zoris

Search took 3 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 Limit538001522.68620029.8
3Display Results1521520.0931634.4
 (SQL Overall)1786911522.87262218.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.