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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
cadges10471671(None) 
badges103917371badges
cades85440731cad_es
cadge94018791cadge_
cadged114812341cadged
cadger105013911cadger
cadgers114712001cadgers
cadres94017931cadres
cages85936011ca_ges
fadges114814031fadges
adages8412952_adages
adzes155913802_adzes
ages55844592_a_ges
badge94819692badge_
badged114814792badged
badger105415082badger
badgers114812652badgers
barges94528252barges
budges104820132budges
cables104527552cables
caches137926912caches
caddies113718382caddies
caddis104613382caddis
cade76443912cad_e_
cadet85339342cad_et
cadets96316512cadets
cadgy125210782cadg_y
cadis84428502cad_is
cadre85419022cadre_
cads76144522cad__s
cafes106426922ca_fes
cage75339062ca_ge_
caged95426362ca_ged
cager85229222ca_ger
cagers95624192ca_gers
cagey115917822ca_gey
cakes116037672ca_kes
calces104420052calces
calves115119282calves
calxes154113032calxes
cames97047312ca_mes
candies104125612candies
candles104422342candles
canes75350372ca_nes
cangues10611822cangues
canoes84725882canoes
capes95441922ca_pes
cares77369182ca_res
cargoes104415222cargoes
cargos94619182cargos
caries85147622caries
carles85435082carles
carses85233652carses
cartes86239472cartes
carves115128452carves
cases75048382ca_ses
cashes114729882cashes
castes85631862castes
cates75951892ca_tes
caudles103912812caudles
caules85927252caules
causes88026472causes
caves105639702ca_ves
cavies114525002cavies
cedes84927332ced_es
changes134517582changes
charges134615982charges
clades94920462clad_es
codes86247292cod_es
codger105814872codger
codgers115113932codgers
conges94928172conges
cradles103114132cradles
cudgel1036702cudgel
cudgels1135332cudgels
dadoes85616532dadoes
dodges96119082dodges
edges75718742_edges
fades94932862fad_es
fadge104817002fadge_
fadged124712362fadged
fidges114114392fidges
fudges114314502fudges
gadget93616182gadget
gadgets10348682gadgets
gages74529972ga_ges
gauges85915992gauges
hades96035112had_es
hadjes175210402hadjes
hedges115016262hedges
jades135222112jad_es
judges153713462judges
kedges124812982kedges
lades65141272lad_es
ladies75124882ladies
ladles74619542ladles
larges74824232larges
ledges84918012ledges
lodges86820152lodges
madres93718182madres
mages85036022ma_ges
manges94628942manges
marges94525712marges
midges103516482midges
nudges84114742nudges
padles95221122padles
padres95016982padres
pages85235072pa_ges
parges94529542parges
rages64539442ra_ges
ranges73826922ranges
ridges85817012ridges
sades65239892sad_es
sadhes104715372sadhes
sages65339062sa_ges
sarges75128592sarges
sedges83817812sedges
targes74524592targes
wades95634142wad_es
wadies105121202wadies
wages95330932wa_ges
wedges114614582wedges
wodges117413682wodges

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511232.54632423.8
3Display Results1231230.0333727.3
 (SQL Overall)1786911232.90961427.0
 
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.