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

321 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
carrions1031244(None) 
carrion9312671carrion_
carryons1337101carryons
barrios9310772barrio_s
camions113916132ca_mions
campions143511292campions
captions123813212captions
carbons115418942ca_rbons
cardons104519932ca_rdons
cardoons113411942cardoons
carious93320282ca_rious
carlins93921912carli_ns
carriers103614202carriers
carries94328012carri_es
carriole1089862carriole
carrioles1169472carrioles
carroms11512402carr_oms
carrots9714622carr_ots
carryon1237032carryon_
cartons94122472ca_rtons
cartoons104012802cartoons
cations94524142ca_tions
cautions103313162cautions
chorions13310652chorions
clarions10310492clarions
garrisons1043792garrisons
garrons82713462garr_ons
marrons93216972marr_ons
morrions1077652morrions
warriors1135362warriors
actions94218513_actions
amnions93710913_amnions
anions64123033_a_nions
aprons8316993_apr_ons
archons12311583_archons
argons75018203_a_rgons
arraigns944343_arraigns
arris56824683_arri__s
arrises71617583_arrises
arrives101311513_arrives
arrows92813483_arr_ows
arsons63917213_a_rsons
avions94114393_a_vions
axions134713483_a_xions
barons85025383ba_r_ons
barrens94414323barr_ens
barriers104311883barriers
barring104021593barri_ng
barrio8312573barrio__
barrooms1237893barrooms
barrows123411683barr_ows
baryons121010473ba_ryons
barytons1345573barytons
basions94213953ba_sions
bastions10411693bastions
cabezons2144543cabezons
cabins104418923ca_bi_ns
cabriole1276933cabriole
cabrioles1376363cabrioles
cains75334303ca__i_ns
cairns85313303ca__irns
caissons1036283caissons
caldrons1138063caldrons
calkins133814873calki_ns
camion103917193ca_mion_
campion133011413campion_
cannons94412883ca_nnons
canons85522063ca__nons
cantons95221203ca_ntons
canyons124511593ca_nyons
caparisons1443673caparisons
caplins113515993capli_ns
capons104119503ca__pons
caprices1439893caprices
caprine11314233capri_ne
capriole1276913capriole
caprioles1376753caprioles
capris10415073capri__s
caption113513693caption_
captious122810563captious
carabins12312353carabins
caracols12310413caracols
caravans1338613caravans
carbanions1455193carbanions
carbarns1238563carbarns
carbides133111693carbides
carbine112918643carbi_ne
carbines123617533carbines
carbinol1245773carbinol
carbinols1346103carbinols
carbon104919043ca_rbon_
carbos105122263ca_rbo_s
carboys144711783ca_rboys
cardamons1445203cardamons
cardiacs1376903cardiacs
cardias10715093cardi_as
cardigans1345143cardigans
carding113922433cardi_ng
cardings123812623cardings
cardio9915673cardio__
cardioid1247433cardioid
cardioids1345223cardioids
carditis11310213carditis
cardon94120853ca_rdon_
cardoon104813813cardoon_
careens94514703ca_reens
cargoes104415223ca_rgoes
cargos94619183ca_rgo_s
carhops14329703ca_rhops
caribes113715643ca_ribes
caribous1258823caribous
carices114220953ca_rices
caries85147623ca_ri_es
carillons1146353carillons
carina84325323ca_ri_na
carinas93622383ca_rinas
caring95137993ca_ri_ng
carioca1139683ca_rioca
cariocas1239663ca_riocas
cariole9818343ca_riole
carioles10817073ca_rioles
caritas93316943ca_ritas
carking144322853carki_ng
carlin84421823carli_n_
carline93923613carli_ne
carlines103521643carlines
carling103727063carli_ng
carlings114015853carlings
carmine112918483carmi_ne
carmines123617863carmines
carnations12311343carnations
carnies94123963carni_es
carns75937563ca_r__ns
carobs104818103ca_r_obs
carols85124983ca_r_ols
caroms105619573ca_r_oms
carotins102315583carotins
carping123521083carpi_ng
carpings133812383carpings
carpools1237883carpools
carracks1637713carracks
carrells10359263carrells
carrels95117303carr_els
carriage1137853carriage
carriages1238333carriages
carried103717153carri_ed
carrier93619583carri_er
carritch1543483carritch
carroch1437093carr_och
carrom10513403carr_o_m
carrot8423123carr_o_t
carrotins11239953carrotins
carroty1248943carr_oty
carrs75730853carr___s
carrying14148363carrying
carryout1346783carryout
carryouts1443433carryouts
carting104228283carti_ng
carton84522663ca_rton_
cartoon94114463cartoon_
cartoony13377403cartoony
carving133916773carvi_ng
carvings143810203carvings
caseins93115053casei_ns
casinos93512833ca_sinos
cassinos10309353cassinos
cation83925503ca_tion_
catkins133012563catki_ns
catlins93818843catli_ns
caution93013513caution_
cautious103110223cautious
cessions1039853cessions
chagrins1437063chagri_ns
champions18875783champions
chariots1339393chariots
charring142913163charri_ng
charros124312143charr_o_s
chorion12311763chorion_
chronons1347353chronons
cions75222853c___ions
cirrous93111063cirr_ous
citrins92614363citri_ns
citrons92913223citr_ons
clarion9311663clarion_
coactions1349733coactions
coercions1346193coercions
coitions10312843coitions
cordons104415763c_ordons
coreigns1136313coreigns
corrasions1246343corrasions
corridas1177303corridas
corridors1245063corridors
corries94026783corri_es
corrosions1245283corrosions
cortins92421313corti_ns
crampons1436643crampons
cratons94316033c_ratons
crayons12439233c_rayons
crepons1139313c_repons
croons85418423c__roons
crotons93714373c_rotons
cullions10219213cullions
curios83218333c_urio_s
curious93813563c_urious
currans9310613curr_ans
curriers103410753curriers
curries93723163curri_es
currijong1941713currijong
currijongs2051403currijongs
curring103616843curri_ng
cushions1335693cushions
cyprians1544213cyprians
dacrons103211033dacr_ons
durions839963_durions
earring83519013earri_ng
earrings9299623earrings
erasions8310983erasions
factions133013063factions
fanions103713073fa_nions
farriers113610743farriers
farrows13259783farr_ows
fashions1437243fashions
fermions1336203fermions
gabions102410053ga_bions
gadroons1037013gadroons
garcons102411643ga_rcons
garring93116713garri_ng
garrison943983garrison_
garron73113493garr_on_
hadrons113314303hadr_ons
harmins123716713harmi_ns
harpins123615703harpi_ns
harpoons1337473harpoons
harridans13154563harridans
harriers113712433harriers
harries103525493harri_es
harrows132611033harr_ows
jargons1558203ja_rgons
jargoons1644663jargoons
jarring153613193jarri_ng
karroos1139313karr_oos
kations114013663ka_tions
ladrons83813193ladr_ons
lampions12277973lampions
lardons83914493la_rdons
lardoons9398483lardoons
larrigans1044013larrigans
larrikins1343783larrikins
macrons113514893macr_ons
mansions1069793mansions
margins103815193margi_ns
marlins93420473marli_ns
maroons92615553ma_roons
marranos1038403marranos
marrieds11288073marrieds
marriers103312473marriers
marries93825283marri_es
marring103319543marri_ng
marron83717543marr_on_
marrows122911813marr_ows
martians103111613martians
martins93322063marti_ns
matrons93517633matr_ons
morions94014633_morions
morrion959003morrion_
narrations1038933narrations
narrows10258843narr_ows
nasions73112383na_sions
nations74720563na_tions
natrons73215663natr_ons
orations81515793orations
pactions122613503pactions
paragons11311503paragons
pardons103817623pa_rdons
parians93519733pa_rians
parriers103612903parriers
parries93925843parri_es
parring103222063parri_ng
parrots9312743parr_ots
parsons93516873pa_rsons
partons94620513pa_rtons
passions10310583passions
patriots1038053patriots
patrons93818103patr_ons
patroons102710603patroons
pereions10310853pereions
perrons93115483perr_ons
portions10514393portions
prions84317783__prions
rampions12248023rampions
rations74123433ra_tions
sadirons936023sadirons
sarins63932623sa_ri_ns
saurians837763saurians
scallions1145773scallions
scansions1145323scansions
scarious10610203sca_rious
scarring112511513scarri_ng
scorpions1344193scorpions
tactions102912423tactions
talions7314093ta_lions
tampions12358113tampions
tardyons1244613tardyons
tarpons92612203ta_rpons
tarragons1044473tarragons
tarriers83411713tarriers
tarries73324263tarri_es
tarring83318303tarri_ng
ternions838813ternions
torsions839183torsions
turions7311573_turions
various103113103va_rious
versions11310353versions
vibrions1345093vibrions
virions1039873_virions
wanions104011373wa_nions
warisons1136903warisons
warrens103810893warr_ens
warring113717973warri_ng
warrior1045363warrio_r
yarrows13277853yarr_ows

Search took 10 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623218.82616560.4
3Display Results3213210.1432244.8
 (SQL Overall)1786913219.12519582.6
 
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.