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

137 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
capitals1220944(None) 
capital112311521capital_
capitols12247331capitols
apicals1159922_apicals
cantals93919572ca_ntals
capias10318352capi_a_s
capita102913772capita__
capitalise1466712capitalise
capitalism1656302capitalism
capitalist1457882capitalist
capitally1646662capitally
capitate121712182capitate
capitol11258282capitol_
capitula1244982capitula
caporals1238922caporals
capstans1257242capstans
captans111612052cap_tans
caritas93316952carita_s
casitas93312042casita_s
lanitals837722lanitals
spitals93011592_spitals
acetals93411353_acetals
agitas7310593_agita_s
animals94111703_animals
apetaly1237253_apetaly
apical10913903_apical_
appals104812943_ap_pals
appeals11378673_appeals
barbitals1345253barbitals
cabals104020153ca__bals
caftans12179443ca_ftans
caimans113811783ca_imans
camisas113411923camisa_s
canals84421663ca__nals
canistels11205393canistels
canities101519263canities
cannibals1354443cannibals
cantal84122033ca_ntal_
cantala94114673ca_ntala
cantalas104013523ca_ntalas
capelans1238013capelans
capfuls1436523cap_fuls
capiases1239253capiases
capitalised1684853capitalised
capitalises1586273capitalises
capitalisms1765503capitalisms
capitalists1555533capitalists
capitalize2347463capitalize
capitalizes2466913capitalizes
capitated14159043capitated
capitella1342613capitella
capitular1343773capitular
capitulum1551993capitulum
capizes20410373capi_zes
caporal11410943caporal_
capotes11314643capot_es
capsidal1345623capsidal_
capstan1137903capsta_n
captain112111063cap_tain
captains121810573cap_tains
captan101613343cap_ta_n
captions123813223captions
captious122810573captious
captives1538623captives
captors113914983cap_tors
caracals12310753caracals
cardinals1247993cardinals
carinal94318233carinal_
carinas93622403carina_s
caritases1139753caritases
carnivals1444493carnivals
carpals113414623ca_rpals
cartels94618123ca_rtels
casita82913703casita__
casuals91410523ca_suals
catalo8314853ca__talo
catalos9414163ca__talos
cattails1038553ca_ttails
cattalo938423ca_ttalo
cattalos1037933ca_ttalos
causals91411183ca_usals
caviars1238623cavi_ars
cavils114014393cavi__ls
cavitary1664963cavitary
cavitate13159833cavitate
cavitates14168963cavitates
cavities131412613cavities
centals94317053c_entals
chapiters1635203chapiters
chital114313883c_hital_
citrals91111673c__itrals
coital84117053c_oital_
copals105018943cop__als
crystals1347173crystals
cubital1137103cubital_
curtals93111623c_urtals
digitals1045433digitals
espials937093espi_als
facials123310743faci_als
fajitas1734253fajita_s
gavials1136603gavi_als
genitals937243genitals
habitans1346623habitans
habitats1346733habitats
hartals10313023ha_rtals
hospitals1443903hospitals
labials9299873labi_als
laminals10339303laminals
lanital7310913lanital_
marital92314183marital_
maximals19325223maximals
naphtols13143693naphtols
nuptials1044303nuptials
occipitals1652083occipitals
orbitals1045713orbitals
palatals1037773palatals
parietals1146863parietals
partials101911953partials
petals84719813__petals
pibals103813083__pibals
pipals104213643__pipals
pitas77427673__pita_s
radials83614633radi_als
radicals112610153radicals
raitas64417673ra_ita_s
ratals64219583ra__tals
recitals1039763recitals
sahiwals1443643sahiwals
sapotas939613sapota_s
spinals93911863_spinals
spirals93212513_spirals
spital83813873_spital_
tapetal938273tapetal_
varietals1244443varietals
vitals94514303__vitals
wapitis1236473wapit_is
zaptiahs2242063zaptiahs

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621377.59319249.6
3Display Results1371370.0632174.6
 (SQL Overall)1786911378.07622126.2
 
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.