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

240 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
caeoma103903(None) 
caeomas1138401caeomas
aboma91114602_aboma
aroma71220142_aroma
cabomba1544082cabomba
caeca93915132cae_ca
canola8313622canola
carom95025562carom_
caroms105619572caroms
chroma132912472chroma
cleome1039082cleome
coma87134852c__oma
abomas101113583_abomas
acedia9310393acedia
acerola947823acerola
aceta74017353ace_ta
acromia1139963acromia
adenoma1045403adenoma
aecia73819283_aecia
aeon45634613_aeo_n
aeons57624653_aeons
agama85815583_agama
agma77623263_a_gma
agora6914333_agora
alma66333023_a_lma
aloha8513613_aloha
ama510853303_a__ma
anima74620073_anima
anoa45634473_ano_a
anomy105113393_anomy
areola6813673areola
aromas81018613_aromas
atma68121773_a_tma
atom67824523_atom_
atoms76817563_atoms
atomy107415193_atomy
bema85825253_be_ma
bregma1134963bregma
cabala103516913cabala
cabana103913563cabana
cabman123812503ca_bman
cabob114616813cabo_b
cabobs124311893cabobs
cabombas1643813cabombas
caca85528083ca__ca
cadenza1943773cadenza
caecal103713733caecal
caecum1238183caecum
caesar8410933caesar
caesura956233caesura
cahoot11416473cahoot
cahow135110943caho_w
cahows14399123cahows
caiman103615663ca_iman
cajole154011183cajole
cajon144513903cajo_n
calamar1149293calamar
calami10313423calami
calesa8412473calesa
calla74827073ca_lla
calm85032363ca_lm_
calms95222353ca_lms
calo64936443calo__
calomel1138073calomel
calory11312843calory
calos74431903calo_s
cam78058983ca__m_
camas96333523ca__mas
cambia124913153cambia
came87648753ca__me
camelia11510433camelia
cameo95924993cameo__
cameoed1238383cameoed
cameos105818003cameo_s
camera10313693camera
camisa103114323camisa
camo85731753ca__mo
camorra11115763camorra
camos95927613camo_s
camp106336453ca__mp
cams87047283ca__ms
cancha134411613cancha
canella9310793canella
canna75919333ca_nna
canoe75627253cano_e
canoed94618953canoed
canoer85121073canoer
canoes84725883canoes
canolas9313993canolas
canon74725303cano_n
canons85522063canons
canopy1337723canopy
canula8312963canula
canzona1836073canzona
capita102913773capita
capo85829213capo__
capon95221873capo_n
capons104119503capons
caporal11410943caporal
capos94826073capo_s
capote10315733capote
caramba1336893caramba
carbora11310703carbora
cardia9916373cardia
carina84325323carina
carioca1139683carioca
carman103920743ca_rman
carob95325223caro_b
carobs104818103carobs
caroch13911763caroch
carol75128613caro_l
caroli85918233caroli
carols85124983carols
caromed123713623caromed
carrom10513403carrom_
carroms11512403carroms
casa65630863ca__sa
casaba1079263casaba
casava1157873casava
caseose939163caseose
caseous9312513caseous
casita82913703casita
cassia83714763cassia
catena8312483catena
caveman1437073caveman
cavort11316173cavort
cayman133613213ca_yman
ceca84820783c_e_ca
ceiba938703c_eiba
cella75420313c_ella
celom9515683celom_
celoms10412123celoms
ceorl7410913c_eorl
ceria75125353c_eria
cesta75419483c_esta
chacma1537903chacma
chaeta11310683chae_ta
chela103916803che_la
chemo12313633che_mo
chemos13311723chemos
chola104718033c_hola
chomp144815663c_homp
chromas142512693chromas
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
cinema1047653cinema
citola838393citola
cleomes1138813cleomes
clomb115714703c_lomb
clomp115615703c_lomp
coca88030643c__oca
cocoa98517883coco_a
cocomat13413623cocomat
coda77029343c__oda
coelom10310423coelom_
coelome1139683coelome
coeloms1139063coeloms
cola66541393c__ola
comae97128423c__omae
comal95125133c__omal
comas95833003c__omas
comb106632113c__omb
come87547703c__ome
comma114514793c_omma
comp106731253c__omp
coomb115615703c_oomb
corona83817403corona
coxa136922963c__oxa
crapola1136913crapola
cream95721343cream_
creams104715253creams
creamy134811363creamy
creme94319323cre_me
creole8913723creole
crewman1435743crewman
cuesta838513cuesta
cupola10317693cupola
cyma116715843c__yma
daemon9279593daemon
dagoba1074943dagoba
derma84918513_derma
eczema1973073ecze_ma
edema8610553ede_ma
enema7612743ene_ma
faena85014203fae_na
gama77035523ga__ma
gamma106116103ga_mma
gemma106311773_gemma
glioma935953glioma
haem95730983hae_m_
haemal113811643hae_mal
haems105517013hae_ms
halma108219253ha_lma
herma105318883_herma
karma113415003ka_rma
lama66635293la__ma
lemma94811033_lemma
lipoma1046753lipoma
magma104513573ma_gma
mama86231583ma__ma
mamma86317913ma_mma
maremma1044463maremma
maxima17568633maxima
mazuma1935603mazuma
myeloma1444043myeloma
myoma1239273_myoma
myxoma2043943myxoma
narcoma1145823narcoma
nema65522523_ne_ma
noma67529463__noma
osteoma945423osteoma
paella8410913paella
paeon74819493paeo_n
paeons83915523paeons
pagoda10487873pagoda
pajama17317653pajama
pakora1247283pakora
panama104213353panama
payola11208113payola
pneuma1035263pneuma
radome9511873radome
ramona8412413ramona
regma84612333_regma
samosa8510203samosa
sapota8310203sapota
sarcoma1147403sarcoma
schema1388373sche_ma
scleroma1274343scleroma
scotoma1155953scotoma
smegma1134113smegma
soma65635293__soma
stemma10328133stemma
stoma75918273_stoma
stroma84313073stroma
taenia6313193taenia
tarama8412733tarama
ulema7109713ule_ma
yeoman1138823_yeoman
zygoma2143493zygoma

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.1431249587.4
2DLD Change Limit1127162406.14018357.7
3Display Results2402400.0763157.9
 (SQL Overall)1786912406.35928100.5
 
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.