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

206 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
caeomas113840(None) 
caeoma1039031caeoma_
abomas101113582_abomas
aromas81018612_aromas
cabombas1643812cabombas
camas96333522ca__mas
canolas9313992canolas
caroms105619572carom_s
chromas142512692chromas
cleomes1138812cleomes
comas95833002c__omas
aboma91114603_aboma_
abomasa11114613_abomasa
abomasi11115493_abomasi
acedias1039773acedias
acerolas1048053acerolas
adenomas1144813adenomas
aeons57624653_aeo_ns
agamas97413453_agamas
agmas85919873_a_gmas
agoras7613343_agoras
almas76629773_a_lmas
alohas9411703_alohas
amas67746293_a__mas
animas84418723_animas
anoas57226493_ano_as
areolas71013863areolas
aroma71220143_aroma_
atmas75721013_a_tmas
atoms76817563_atom_s
bemas96424283_be_mas
cabalas113516003cabalas
cabanas112413033cabanas
cabman123812503ca_bman
cabobs124311893cabo_bs
cabomba1544083cabomba
cacas95627983ca__cas
cadenzas2053743cadenzas
caeca93915133cae_ca_
caecal103713733cae_cal
caesar8410933cae_sar
caesars9410733caesars
caestus947773caestus
caesuras1055733caesuras
cahoots1238473cahoots
cahows14399123caho_ws
caiman103615663ca_iman
caimans113811783ca_imans
cajoles163712103cajoles
cajones163311333cajones
calamar1149293calamar
calamars1238133calamars
calamus1139243calamus
calesas9411833calesas
callas84526753ca_llas
calms95222353ca_lm_s
calomel1138073calomel
calomels1236133calomels
calos74431903calo__s
camass104114183ca__mass
camelias12510303camelias
cameos105818003cameo__s
cameras11313363cameras
cames97047313ca__mes
camisas113411923camisas
camorras12116503camorras
camos95927613ca__mos
camps116330263ca__mps
cams87047283ca__m_s
canchas143212403canchas
canellas10310563canellas
cannas84518403ca_nnas
canoers94318373canoers
canoes84725883cano_es
canola8313623canola_
canons85522063cano_ns
canulas9312853canulas
canvas113813333ca_nvas
canzonas1935383canzonas
capias10318353ca_pias
capons104119503capo_ns
caporal11410943caporal
caporals1238923caporals
capos94826073capo__s
capotes11314643capotes
carboras12311583carboras
cardias10715113cardias
carinas93622403carinas
cariocas1239663cariocas
caritas93316953caritas
carman103920743ca_rman
carobs104818103caro_bs
carols85124983caro_ls
carolus94612603carolus
carom95025563carom__
caromed123713623caromed
carroms11512403carrom_s
casabas1139983casabas
casas75327843ca__sas
casavas1237813casavas
caseoses1039293caseoses
caseous9312513caseo_us
casitas93312043casitas
cassias93514343cassias
catenas9313113catenas
caveman1437073caveman
cavorts1237933cavorts
cayman133613213ca_yman
caymans14349513ca_ymans
ceibas1038503c_eibas
celoms10412123celom_s
centas85020703c_entas
ceorls848163c_eorls
cerias83321983c_erias
cestas85018543c_estas
chacmas1638003chacmas
chelas113817203che_las
chemos13311723che_mos
cholas114818003c_holas
chomps155112223c_homps
chroma132912473chroma_
chromes142914933chromes
chromos142610273chromos
cinemas1138043cinemas
citolas939363citolas
cleome1039083cleom_e
clomps125212233c_lomps
cocas95926573c__ocas
cocoas104915743coco_as
cocomat13413623cocomat
cocomats1449403cocomats
codas84724243c__odas
coelomes1239293coelomes
coeloms1139063coelom_s
colas75436773c__olas
coma87134853c__oma_
comae97128423c__omae
comal95125133c__omal
combs116122963c__ombs
comes97246993c__omes
commas124814573c_ommas
compas125817063c__ompas
comps115526053c__omps
coombs124210193c_oombs
coronas93916913coronas
crapolas1247403crapolas
creams104715253cream_s
cremes104517993cre_mes
creoles9913323creoles
crewman1435743crewman
cuestas957933cuestas
cupolas11277753cupolas
cymas126417883c__ymas
daemons10269233daemons
dagobas1145143dagobas
dermas94116813_dermas
eczemas2063143ecze_mas
edemas9310503ede_mas
enemas8812003ene_mas
faenas94412763fae_nas
gamas85431363ga__mas
gammas115714693ga_mmas
gliomas1035333gliomas
haemal113811643hae_mal
haems105517013hae_m_s
halmas117017893ha_lmas
karmas123013733ka_rmas
lamas75532793la__mas
lemmas10349163_lemmas
lipomas1156443lipomas
magmas115512503ma_gmas
mamas95930773ma__mas
mammas94616403ma_mmas
mazumas2034623mazumas
myelomas1544323myelomas
myomas1338303_myomas
myxomas2153913myxomas
narcomas1246043narcomas
nemas75321573_ne_mas
nomas74726413__nomas
osteomas1045323osteomas
paellas9411413paellas
paeons83915523paeo_ns
pagodas11367553pagodas
pajamas18278153pajamas
pakoras1337473pakoras
panamas113112763panamas
payolas12148973payolas
pneumas1145103pneumas
radomes10311053radomes
ramonas9311093ramonas
samosas939293samosas
sapotas939603sapotas
sarcomas1247223sarcomas
schemas1468163sche_mas
scleromas1364313scleromas
scotomas1256263scotomas
smegmas1233503smegmas
somas76030373__somas
stemmas11256973stemmas
stomas84816323_stomas
taenias7311283taenias
taramas9612703taramas
ulemas888963ule_mas
yeoman1138823_yeoman
zygomas2243413zygomas

Search took 9 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.216827273.1
2DLD Change Limit1340272067.89316980.5
3Display Results2062060.0932215.1
 (SQL Overall)1786912068.20221786.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.