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 “cameral” 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
cameral1131128(None) 
camera10313691camera_
camerae11312061camerae
cameras11313361cameras
amoral8314632_amoral
bicameral1553092bicameral
caecal103713732ca_ecal
cambial134010762cambial
camel96822802came__l
caporal11410942caporal
carceral1247192carceral
cateran9313772cateran
gametal1037602gametal
gomeral1038832gomeral
humeral1238562humeral
lateral7313572lateral
numeral939082numeral
aboral8314373_aboral
acetal84314903_acetal
achiral12109183achiral
admiral1046363admiral
aerial64625713_a_erial
ameba9312383_ameba_
amebae1049633_amebae
ameban1039093_ameban
amebas10311453_amebas
amerce10310513_amerce
amtrac10109123_amtrac
antral65719413_antral
anural65714743_anural
apteral9311523apteral
areal55928733_are_al
astral66919283_astral
aural54428963_a_ural
balmoral1244633balmoral
bimetal1138433bimetal
cabal95222153ca__bal
caber95126833caber__
cabers105023923caber_s
caeca93915133ca_eca_
caesar8410933ca_esar
caesural1055393caesural
cageful1356483cageful
cager85229223cager__
cagers95624193cager_s
cakewalk1643263cakewalk
caldera1037963caldera_
calderas1147883calderas
calendal1145383calendal
calesa8412473calesa_
calesas9411833calesas
calmer105216933calmer__
caltrap11297943caltrap
camail10314833cam_ail
camas96333523cam__as
camber124418483camber__
cambered15129003cambered
cambers134017443camber_s
cambia124913153cambia_
cambric1537383cambric
came87648753came___
camelia11510433camelia
camelias12510303camelias
camelid1249413camelid
camels105217083came_ls
cameo95924993came__o
cameoed1238383cameoed
cameos105818003came_os
cameraman1542913cameraman
cameramen1544133cameramen
cames97047313came__s
camisa103114323camisa_
camisas113411923camisas
camorra11115763camorra
camorras12116503camorras
camper124722213camper__
campers134220293camper_s
campestral1652373campestral
camphol1645793camphol
canal75428043ca__nal
canella9310793canella
caner75334773caner__
caners84629203caner_s
cantal84122033ca_ntal
canthal12410053canthal
cantrap113310283cantrap
capelan1139003capelan
caper94831623caper__
capered123014043capered
caperer113013403caperer
capers105428143caper_s
capital112311523capital
caporals1238923caporals
caracal11312513caracal
carat75048793ca__rat
careful1249113careful
carer74942333carer__
carers85133963carer_s
carinal94318233carinal
carl65144783ca__r_l
carnal83919203ca_rnal
carol75128613ca__rol
carpal103716253ca_rpal
carrel84718633ca_rrel
carrell94610473carrell
casern84713313caser_n
caserne93710063caserne
caserns94711223caserns
casual81112863ca_sual
catena8312483catena_
catenae9311373catenae
catenas9313113catenas
cater74840723cater__
caterans10313223caterans
catered103117773catered
caterer92815943caterer
caters85336503cater_s
caterwaul1442943caterwaul
cathedral15104383cathedral
caudal91611483ca_udal
causal81413203ca_usal
caveat11417723cave_at
caveman1437073caveman
caver105629063caver__
cavern115312453caver_n
caverns124510253caverns
cavers115026843caver_s
cecal94619113c__ecal
central93114473central
cercal10314123c__ercal
cereal8315833c__ereal
cerebral1266183cerebral
chaetal1238283chaetal
chambray2043143chambray
chapteral1644703chapteral
chimera14389273chimera_
chimeras15388833chimeras
chiral114614413c_hiral
chloral12169983chloral
choral115118493c_horal
choreal124412223choreal
citral81113893c_itral
coaeval1245183coaeval
coeval1138893c_oeval
comal95125133com__al
comer95832693comer__
comers105328083comer_s
comical13312223comical
coral76033453c__oral
corral83616253c_orral
coverall1347603coverall
credal9311673c_redal
creedal1037093creedal
crural8610633c_rural
cuneal8611513cune_al
cymbal15236913cym_bal
daedal849083da_edal
demersal1145263demersal
diametral1243803diametral
emerald1046923_emerald
enteral73516443enteral
faecal11359813fa_ecal
falderal12104803falderal
federal1148533federal
femoral1238723femoral
feral85424653__feral
funeral1037623funeral
gambrel1235453gambrel
gamelan10106643gamelan
gamer84928943gamer__
gamers94420833gamer_s
gastral8329553gastral
general81010933general
gomerals1147443gomerals
gomerel1036393gomerel
gomeril1047383gomeril
haemal113811643ha_emal
hamal104623113ham__al
hammal134512063ham_mal
haverel13397153haverel
humerals1347173humerals
humoral1237973humoral
hymenal1545183hymenal
immoral1146783immoral
lamella988613lamella
lamer75233703lamer__
laminal94113633laminal
laterad8310843laterad
laterals8312753laterals
liberal9310193liberal
literal7613273literal
lumenal9307273lumenal
mammal95112753mam_mal
material10314103material
maternal1047803maternal
mayoral1237693mayoral
meal65643173__me_al
medal86221333__medal
merl65830973__mer_l
metal75427383__metal
mineral9312733mineral
moral75533433__moral
mural75225113__mural
nadiral836343nadiral
namer75622103namer__
namers84517333namer_s
nametag1044443nametag
natural739513natural
numerals1047333numerals
oatmeal944973oatme_al
paleal84716673pale_al
papyral1445773papyral
parral85517533pa_rral
paternal1038333paternal
puberal1147773puberal
ramal74622243ram__al
ruderal837373ruderal
sacral83414413sa_cral
samara8313853samara_
samaras9312913samaras
sambal105215183sam_bal
samurai945923samurai
scleral937863scleral
seral56336383__seral
several1039533several
spheral1238423spheral
tamal73522623tam__al
tamarao977593tamarao
tamarau9107063tamarau
tamer75230103tamer__
tamers84224033tamer_s
tapetal938273tapetal
timbral11237193timbral
tumoral938133tumoral
umbral1038633_umbral
unicameral1451883unicameral
unmoral948693unmoral
wameful1535673wameful
womera11137593womera_
womeras1287593womeras

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.466383457.1
2DLD Change Limit1340272407.64017542.8
3Display Results2402400.0803000.0
 (SQL Overall)1786912408.18621828.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.