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

116 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
carriages123833(None) 
carriage1137851carriage_
marriages1247381marriages
barrages11711082barr_ages
carnages11312212ca_rnages
carries94328012carri__es
carrioles1169472carrioles
cartages11313312ca_rtages
cartilages1345512cartilages
cartridges1472832cartridges
ferriages1345662ferriages
marriage1147252marriage_
parridges1384552parridges
abridges1245303_abridges
acariases1146613acariases
acreages1138373_acreages
arraigns944353_arraigns
arranges939413_arranges
arrases71214543_arr_ases
arrises71617583_arri_ses
arrives101311513_arri_ves
baronages1247153baronages
barrage10710843barr_age_
barraged1297683barr_aged
barrelages1343623barrelages
barricades1564203barricades
cabbages1537203ca_bbages
cabotages1444853cabotages
cabrioles1376363cabrioles
capiases1239253ca_piases
caprices1439893capri_ces
caprioles1376753caprioles
carafes125015703ca_r_afes
carapaces1546053carapaces
carapaxes2044833carapaxes
carates95630613ca_r_ates
carbides133111693carbi_des
carbines123617533carbi_nes
carcases12313093ca_rcases
cardcases1446503cardcases
cardiacs1376913cardia_cs
cardiae10713703cardia_e_
cardias10715113cardia__s
cardigans1345153cardigans
cardings123812633carding_s
caretakes1547143caretakes
carfares13310323ca_rfares
caribes113715643ca_ri_bes
carices114220953ca_ri_ces
caries85147623ca_ri__es
carioles10817073ca_rioles
caritases1139753caritases
carlines103521643carli_nes
carlings114015853carling_s
carmines123617863carmi_nes
carnage10311743ca_rnage_
carnies94123963carni__es
carnifies1439893carnifies
carpings133812383carping_s
carracks1637713carr_acks
carrageen1274013carr_ageen
carrageens1363303carr_ageens
carriageway2061173carriageway
carriageways216903carriageways
carried103717153carri__ed
carrier93619583carri__er
carriers103614203carri_ers
carriole1089863carriole_
carrions10312453carri_ons
carritches1743083carritches
carroches1665893carroches
carronades1345763carronades
carryalls1443523carryalls
cartage10312593ca_rtage_
cartilage1245533cartilage_
cartridge1372723cartridge_
carvings143810203carving_s
catrigged1442963catrigged
caviares1337993ca_viares
cordages12310113c_ordages
corkages1539103c_orkages
corrades111211263corr_ades
corries94026793corri__es
corsages11310363c_orsages
courages11311393cour_ages
craniates11310653craniates
cringes103215503c__ringes
curraghs1442883curr_aghs
curricles13105423curricles
curries93723163curri__es
curtilages1343193curtilages
earringed1144453earringed
earrings9299633earring_s
farragoes1344633farr_agoes
ferriage1245463ferriage_
garages9314113ga_r_ages
garbages1238183ga_rbages
harries103525493harri__es
larrigans1044013larrigans
marries93825283marri__es
miscarriages1781743miscarriages
narrates8312763narr_ates
parridge1254333parridge_
parries93925843parri__es
partridges1453053partridges
patriates11311363patriates
porridges1343913porridges
remarriages1452203remarriages
tarriances1244213tarriances
tarries73324263tarri__es
triages82613793__triages
variates111214983va_riates
verbiages1544683verbiages
warpages1437053wa_rpages
warrigals1343773warrigals
yardages1336203ya_rdages

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411167.64019455.6
3Display Results1161160.0631841.3
 (SQL Overall)1786911168.13921954.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.