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

194 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
calomel113807(None) 
calomels1236131calomels
calmed114816382cal_med
calmer105216932cal_mer
caloyer1238142caloyer
calumet11313292calumet
camel96822802ca__mel
caramel11310252caramel
caromed123713622caromed
colonel94213282colonel
columel1136272columel
alme65832163_al_me_
almeh106214553_al_meh
almes75126543_al_mes
aloe45540193_alo_e_
aloes54933673_alo_es
alone55732963_alone_
aludel747853_aludel
baloney1237483baloney
cabmen123610653ca_bmen
cabomba1544083cabomba
cacodyl1543213cacodyl
cacomixl2142093cacomixl
caeoma1039033caeom_a
caeomas1138393caeomas
cajole154011183cajole_
cajoled17428273cajoled
cajoler16398393cajoler
cajoles163712103cajoles
cajones163311333cajones
calamar1149293calamar
calami10313423calam_i
calamus1139243calamus
calces104420053cal_ces
caliber1139733caliber
calices114321693calices
calicle113111433calicle
calipee11412913calipee
caliper11410963caliper
calked134617403cal_ked
calker124917083cal_ker
call66838673cal___l
called94126733cal_led
callee84327293cal_lee
callees94117783callees
caller85125483cal_ler
callet84536763cal_let
callose9313663callose_
calloses10313393calloses
callower13159073callower
calm85032363cal_m__
calmest11312343cal_mest
calmly1337613cal_mly
calms95222353cal_m_s
calo64936443calo___
caloric113413213caloric
calorie92716883calorie
calories102919543calories
calory11312843calo_ry
calos74431903calo__s
calotte9510563calotte
calottes10610083calottes
caloyers1337343caloyers
calque17289843calque_
calqued19306523calqued
calques182710193calques
calumets1236283calumets
calumny1443863calumny
calve105919923cal_ve_
calved125215453cal_ved
calves115119283cal_ves
calxes154113033cal_xes
calyceal1543043calyceal
calyces14428803calyces
calycle14245833calycle
calyxes19426233calyxes
calzone1848623calzone_
calzones1948763calzones
came87648753ca__me_
camels105217083ca__mels
cameo95924993ca__meo
cames97047313ca__mes
camomile14156323camomile
cancel105316683ca_ncel
cannel84216403ca_nnel
canoe75627253cano_e_
canoed94618953cano_ed
canoer85121073cano_er
canoes84725883cano_es
caporal11410943caporal
capote10315733capote_
capotes11314643capotes
capsomer1445773capsomer
caramels1238803caramels
caravel1238203caravel
carcel105018673ca_rcel
carmen104019343ca_rmen
carol75128613caro__l
caroled103717683caroled
caroler93816753caroler
carom95025563carom__
caroms105619573carom_s
carousel1057313carousel
carpel105418473ca_rpel
carrel84718633ca_rrel
carromed1338563carromed
cartel85022533ca_rtel
carvel114817573ca_rvel
cavemen1437143cavemen
celom9515683celom__
celoms10412123celom_s
celotex1635023celotex
chalone12312103chalone_
chalones13312173chalones
chloral12169983chloral
chrome133214813chrome_
chromed153510923chromed
chromes142914933chromes
chromyl17275233chromyl
claimed12298833claimed
claimer11279883claimer
clammed14369963clammed
clammer134211793clammer
cleome1039083cleome_
cleomes1138813cleomes
clime95720893c_lime_
climes104720003c_limes
clomb115714703c_lom_b
clomp115615703c_lom_p
clomped14398973c_lomped
clomps125212233c_lomps
clonal8310913c_lonal
clone75728163c_lone_
cloned94518803c_loned
cloner84418093c_loner
clones84526563c_lones
close76425223c_lose_
closed95317963c_losed
closely1237053c_losely
closer84918203c_loser
closes85425593c_loses
closet85226603c_loset
clove105619443c_love_
cloven114211513c_loven
clover114617123c_lover
cloves114918823c_loves
cloyed125111563c_loyed
cloze165517543c_loze_
clozes174915563c_lozes
coelome1139683coelome_
coelomes1239293coelomes
colone85425003colone_
colonels104210453colonels
colones96124433colones
colored10313473colored
colorer9312523colorer
colormen1247243colormen
columels1244813columels
comal95125133c__omal
come87547703c__ome_
comely134213733c__omely
comer95832693c__omer
comes97246993c__omes
comet95946073c__omet
compel124412893c__ompel
cormel103815603c_ormel
coronel94515223coronel
culmed114610593cul_med
damosel10126693damosel
damozel19184353damozel
falafel1383903falafel
galoped11138063galoped
galore73514843galore_
galores82614323galores
hallel93514093hal_lel
haloed104717593halo_ed
haloes94623863halo_es
halogen1138393halogen
losel54419423__losel
oenomel946563oenomel
oinomel946353oinomel
palmed114314643pal_med
palmer105816543pal_mer
philomel1544083philomel
radome9511873radome_
radomes10311043radomes
salol55222143salo__l
scalpel11377713scal_pel
slalomed1134283slalomed
slalomer1045033slalomer
taloned8310223taloned
telome8311923telome_
telomes9310533telomes
wadmel1235523wa_dmel

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271947.47017942.0
3Display Results1941940.0603233.3
 (SQL Overall)1786911947.68623248.9
 
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.