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 “carceral” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
carceral124720(None) 
cameral11311282ca_meral
carcel105018672carce__l
acetal84314903_a_cetal
apteral9311523_apteral
areal55928733_ar_e_al
arsenal739383_arsenal
arterial8313633_arterial
caecal103713733ca__ecal
caesural1055393caesural
caldera1037963caldera_
calderas1147883calderas
calyceal1543043calyce_al
camera10313693ca_mera_
camerae11312063ca_merae
cameras11313363ca_meras
cancel105316683cance__l
cancer104220923cancer__
cancered132411553cancered
cancers114018583cancer_s
caporal11410943ca_poral
caracal11312513car_acal
caracara1247263caracara_
caracaras1346863caracaras
carbaryl1544423carbaryl
carbora11310703carbora_
carboras12311583carboras
carcels114516063carce_ls
carder94524183carder__
carders104820353carder_s
cardinal1139573cardinal
career85822243career__
careered1139493careered
careerer1038583careerer
careers95218783career_s
careful1249113car_eful
carer74942333car_er__
carers85133963car_er_s
carinal94318243car_inal
carnal83919213car__nal
carnival1345623carnival
carousal1056283carousal
carpal103716253car__pal
carpel105418473carpe__l
carper104923633carper__
carpers114521253carper_s
carrel84718633car__rel
carrell94610473carre_ll
cartel85022533carte__l
carter84932273carter__
carters95327253carter_s
carvel114817573carve__l
carver114420153carver__
carvers124817543carver_s
cascara1138313cascara_
cascaras1237703cascaras
cateran9313773ca_teran
cathedral15104383cathedral
cercal10314123cerc__al
cercarial1346033cercarial
cereal8315833cer_e_al
cerebral1266183cerebral
chapteral1644703chapteral
charcoal15165743charc_oal
conceal113313013conce_al
corneal94414503corne_al
corporal1248513corporal
corral83616253cor__ral
credal9311673c_r_edal
creedal1037093c_reedal
crural8610633c_r_ural
falderal12104803falderal
farcer115016083farcer__
farcers124713443farcer_s
farcical1546953farcical
lateral7313573la_teral
macrural1244963macrural
marcel103714853marce__l
parcel103915473parce__l
parietal1048773parietal
parral85517533par__ral
sacral83414413sa_c_ral
scarcer113911373scarcer__
varietal1145613varietal
visceral1344673visceral

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 Filter1786911461620.420425454.8
2DLD Change Limit146162856.79621507.1
3Display Results85850.0332575.8
 (SQL Overall)178691857.24924650.4
 
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.