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

129 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
cottager1130680(None) 
cottage104210571cottage_
cottagers12305371cottagers
cottages113310491cottages
cottagey14305231cottagey
cottae84615702cotta_e_
cottar84613812cotta__r
cotter84926672cott__er
cottier93814172cott_ier
cuttage10318342cuttage_
cuttages11297222cuttages
pottage103310602pottage_
pottages112910452pottages
bottler94211883bott_ler
bottomer1245103bottomer
cager85229223c___ager
cartage10312593cartage_
cartages11313313cartages
catnaper1294933catnaper
cattier93317073catt_ier
coaler84121703co__aler
coater84329553co__ater
coaxer153912783co__axer
codger105814843co__dger
coinage10310553coinage_
coinages11310803coinages
coleader1139173coleader
collage102813753collage_
collaged12279963collaged
collagen11338563collagen
collages113514233collages
colleger11227923colleger
colter84625093colt__er
comaker153410603co_maker
comanager1444533comanager
combater1439373combater
comparer143611363comparer
conger95024273co__nger
contagia1156773contagia
container11311073container
cooter85128613coot__er
copter109822013copt__er
cordage11310063cordage_
cordages12310113cordages
corkage1438373corkage_
corkages1539103corkages
corsage1039803corsage_
corsages11310363corsages
cortege1098943cortege_
corteges1198813corteges
costae85319683costa_e_
costar85518613costa__r
costate94019273costate_
coster84331293cost__er
costlier1038523costlier
costumer1275103costumer
cotta75818573cotta___
cottars94412233cotta_rs
cottas84615573cotta__s
cottered112511733cottered
cotters94323433cott__ers
cottiers10399153cott_iers
cottoned1138033cottoned
courage10310993courage_
courages11311393courages
couter84930203cout__er
couther123914623cout_her
couthier13218903couthier
cowage12310663co_wage_
cowages13310933co_wages
cowhage1636293cowhage_
cowhages1736103cowhages
cutter84520993cutt__er
cutwater1344823cutwater
dotage82711613do_tage_
dotages92311793do_tages
dotter74419343dott__er
dottier83910923dott_ier
dowager1245803do_wager
ecotage1036883eco_tage_
ecotages1136973eco_tages
footage1148833footage_
footages1239043footages
forager114412553fo_rager
frottage1245073frottage_
frottages1384983frottages
homager13107853ho_mager
hostage113111233hostage_
hostages122311693hostages
hotter94720073hott__er
jotter134315633jott__er
lotter64025603lott__er
montage101211713montage_
montaged12107763montaged
montages111412183montages
mortgager1342503mortgager
mottler94410343mott_ler
onager739663_o_nager
ottar54313993_otta__r
otter54423973_ott__er
outage72017533_outage_
outages82317323_outages
plottage1144433plottage_
plottages1244243plottages
portage103013643portage_
portaged12228463portaged
portages112613223portages
postage103214853postage_
postages112815323postages
potage92715903po_tage_
potages102416423po_tages
potter83926983pott__er
potterer102310263potterer
pottier93516493pott_ier
rootage839043rootage_
rootages939093rootages
rottener8216973rottener
rotter64325463rott__er
socager10107703so_cager
stager74821343__stager
totter65021463tott__er
totterer8217793totterer
upstager11164633upstager
vintager12104823vintager
voltage1136863voltage_
voltages1237253voltages
voyager1433513vo_yager
wattage1186983wattage_
wattages12106783wattages

Search took 7 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.1701051123.5
2DLD Change Limit1461621296.58022213.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.79626293.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.