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

217 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
camerae1131206(None) 
camera10313691camera_
cameral11311281cameral
cameras11313361cameras
amebae1049632_amebae
amerce10310512_amerce
cameramen1544132cameramen
caserne93710062caserne
catenae9311372catenae
cateran9313772cateran
acerate92818913_acerate
acierate10311813acierate
aerate64830553_a_erate
aerie54634603_a_erie
agorae7511203_agorae
ameba9312383_ameba_
ameban1039093_ameban
amebas10311453_amebas
ameerate1039633_ameerate
amerced1256523_amerced
amercer1146373_amercer
amerces1149853_amerces
amesace1147733_amesace
amirate91115953_amirate
amoebae1145533_amoebae
amoral8314633_amoral
amperage1347743_amperage
ampere10514413_amper_e
amtrac10109123_amtrac
areae55229743_are_ae
aurae54128113_a_urae
average1158853_average
averse95811183_averse
bicameral1553093bicameral
caber95126833caber__
cabernet12410763cabernet
cabers105023923caber_s
cadelle1039923cadelle
cadence1239063cadence
cadre85419023ca_dr_e
caeca93915133ca_eca_
caecal103713733ca_ecal
caesar8410933ca_esar
caesurae1055123caesurae
cager85229223cager__
cagers95624193cager_s
caldera1037963caldera_
calderas1147883calderas
caleche14297943caleche
calesa8412473calesa_
calesas9411833calesas
calmer105216933calmer__
calorie92716893calorie
caltrap11297943caltrap
camas96333523cam__as
camber124418483camber__
cambered15129003cambered
cambers134017443camber_s
cambia124913153cambia_
cambial134010763cambial
cambric1537383cambric
came87648753cam___e
camel96822803came__l
cameleer1246033cameleer
camelia11510433camelia
camelias12510303camelias
camelid1249413camelid
camels105217083came_ls
cameo95924993came__o
cameoed1238383cameoed
cameos105818003came_os
cameraman1542913cameraman
cames97047313came__s
camisa103114323camisa_
camisade1374823camisade
camisas113411923camisas
camise103319633cam_ise
cammie124615293cam_mie
camorra11115763camorra
camorras12116503camorras
camper124722213camper__
campers134220293camper_s
camporee1449343camporee
canebrake1743693canebrake
caner75334773caner__
caners84629203caner_s
caneware1347803caneware
cantrap113310283cantrap
canulae9311183canulae
capelan1139003capelan
caper94831623caper__
capered123014043capered
caperer113013403caperer
capers105428143caper_s
caporal11410943caporal
carafe115416163ca__rafe
carat75048793ca__rat
carate84734003ca__rate
carceral1247203carceral
cardiae10713703cardiae
care66968373ca__r_e
carefree1346343carefree
carer74942333carer__
carers85133963carer_s
caretake1446773caretake
carfare12310073carfare
carinae94318583carinae
carle74535703ca__rle
carse74934333ca__rse
carte75940423ca__rte
carve106227753ca__rve
casease939323casease
caseate9314783caseate
casemate1239843casemate
caseose939163caseose
casern84713313caser_n
casernes103810753casernes
caserns94711223caserns
casette9310393casette
cashmere1564323cashmer_e
casimere1254793casimer_e
castrate10313863castrate
catena8312483catena_
catenas9313113catenas
catenate10312833catenate
cater74840723cater__
caterans10313223caterans
catered103117773catered
caterer92815943caterer
caters85336503cater_s
cathedrae15104233cathedrae
causerie1078273causerie
caveat11417723cave_at
caveman1437073caveman
caver105629063caver__
cavern115312453caver_n
caverned1436163caverned
caverns124510253caverns
cavers115026843caver_s
caviare1238373caviare
cayenne1244603cayenne
cerate84829463c__erate
cere66741473c__er_e
cesurae937703cesurae
chaetae1238603chaetae
chambray2043143chambray
chelae113614603c_helae
chimera14389273chimera_
chimeras15388833chimeras
chimere144010633chimer_e
coerce10310403c_oerce
cohere112716993coher_e
comae97128423com__ae
comer95832693comer__
comers105328083comer_s
commerce16116323commerce
compare135814993compare
compere134616623comper_e
comrade12139213com_rade
coterie9417403coterie
coverage1438733coverage
cymae126713013cym__ae
cymene1377393cyme_ne
demerge11168023demerge
emerge91510463_emerge
faerie93514683fa_erie
galeae74717453gale_ae
galere73716673galer_e
gamelan10106643gamelan
gamer84928943gamer__
gamers94420833gamer_s
gametal1037603gametal
gamete9313593game_te
gomeral1038833gomeral
humeral1238563humeral
immerge1244703immerge
immerse1145793immerse
lacerate102214703lacerate
lamellae10117033lamellae
lamer75233703lamer__
lamiae84817453lam_iae
laminae93512973laminae
laterad8310843laterad
lateral7313573lateral
laurae64011663la_urae
layerage1244963layerage
macerate122314073macerate
mammae94613213mam_mae
merde84320123__merde
mere67244443__mer_e
merge84523693__merge
merle75824373__merle
morae75831193__morae
namer75622103namer__
namers84517333namer_s
namesake1443243namesake
nametag1044443nametag
numeral939083numeral
numerate101610393numerate
paleae84820293pale_ae
parae76335703pa__rae
ramee74633853rame__e
remerge10148923remerge
samara8313853samara_
samaras9312913samaras
samurai945923samurai
sclerae937933sclerae
tamarao977593tamarao
tamarau9107063tamarau
tamer75230103tamer__
tamers84224033tamer_s
umbrae1038683_umbrae
valerate11311473valerate
vambrace1743983vambrace
waterage1248663waterage
womera11137593womera_
womeras1287593womeras

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.406440125.6
2DLD Change Limit1340272176.61020276.4
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.09225196.1
 
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.