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

112 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
cadge9401879(None) 
badge94819691badge
cade76443911cad_e
cadged114812341cadged
cadger105013911cadger
cadges104716711cadges
cadgy125210781cadgy
cadre85419021cadre
cage75339061ca_ge
fadge104817001fadge
adage7414052_adage
adze1412820572_adze
age47154332_a_ge
bade75140882bad_e
badged114814792badged
badger105415082badger
badges103917372badges
barge85631022barge
budge94619882budge
cable95329912cable
cache125122482cache
cad67456362cad__
caddie104316452caddie
caddy125414022caddy
cades85440732cades
cadet85339342cadet
cadgers114712002cadgers
cadi75732182cad_i
cadis84428502cadis
cadres94017932cadres
cads76144522cad_s
cafe95230322ca_fe
caged95426362ca_ged
cager85229222ca_ger
cages85936012ca_ges
cagey115917822ca_gey
cagy106321992ca_gy
cake105439962ca_ke
calve105919922calve
came87648752ca_me
candle94321482candle
cane66653122ca_ne
cangue91012442cangue
canoe75627252canoe
cape87242782ca_pe
care66968372ca_re
cargo85322072cargo
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
case65848082ca_se
caste75932362caste
cate66254602ca_te
caudle93912912caudle
cause75225352cause
cave95941262ca_ve
cavie104621592cavie
cede74928772ced_e
change124116752change
charge125114212charge
clade85821012clad_e
code77347732cod_e
codger105814872codger
conge85227592conge
cradle93313162cradle
cudgel1036702cudgel
dodge86618132dodge
edge65719682_edge
fade85736342fad_e
fadged124712362fadged
fadges114814032fadges
fidge104516062fidge
fudge105315532fudge
gadget93616182gadget
gadje1457742gadje
gage65936102ga_ge
gauge76117902gauge
hade85440192had_e
hedge105317352hedge
jade125325442jad_e
judge144714162judge
kedge115513732kedge
lade56345982lad_e
ladle66320442ladle
large65325462large
ledge76519492ledge
lodge76520092lodge
made75440242mad_e
madre85720172madre
mage75739132ma_ge
mange84930192mange
marge85328332marge
midge95016552midge
nudge74616432nudge
padle84522342padle
padre86018162padre
page76036102pa_ge
parge85831852parge
rage55742352ra_ge
range64728412range
ridge75018672ridge
sade55544472sad_e
sadhe94815132sadhe
sage55044592sa_ge
sarge65531132sarge
sedge75019972sedge
targe65227092targe
wade85237062wad_e
wage84834082wa_ge
wedge105215662wedge
wodge107212932wodge

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 Filter178691538000.313570897.8
2DLD Change Limit538001121.78030224.7
3Display Results1121120.0333393.9
 (SQL Overall)1786911122.12684050.3
 
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.