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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
cottagers1230537(None) 
cottager11306801cottager_
cottages113310491cottage_s
cottage104210572cottage__
cottagey14305232cottage_y
cottars94412232cotta__rs
cotters94323432cott__ers
cottiers10399152cott_iers
cuttages11297222cuttage_s
pottages112910452pottage_s
bottlers103810013bott_lers
bottomers1344353bottomers
cagers95624183c___agers
cartages11313313cartage_s
catnapers1364753catnapers
coalers94419333co__alers
coaters93525773co__aters
coaxers164311063co__axers
codgers115113923co__dgers
coinages11310803coinage_s
coleaders1237803coleaders
collagens12256033collagens
collages113514233collage_s
collegers12256833collegers
colters93522433colt__ers
comakers16339163co_makers
comanagers1543833comanagers
combaters1538093combaters
comparers15319383comparers
congers104223233co__ngers
containers1249903containers
cooters94525713coot__ers
copters113621273copt__ers
cordages12310113cordage_s
corkages1539103corkage_s
corsages11310363corsage_s
corteges1198813cortege_s
costars94217993costa__rs
costers94128303cost__ers
costumers1374853costumers
cottae84615703cotta_e__
cottar84613813cotta__r_
cottas84615573cotta___s
cotter84926673cott__er_
cottier93814173cott_ier_
courages11311393courage_s
couters93827283cout__ers
cowages13310933co_wage_s
cowhages1736103cowhage_s
cuttage10318343cuttage__
cutters94218953cutt__ers
cutwaters1443603cutwaters
dotages92311793do_tage_s
dotters83715973dott__ers
dowagers1334893do_wagers
ecotages1136973eco_tage_s
footages1239043footage_s
foragers12349623fo_ragers
frottages1384983frottage_s
homagers1486823ho_magers
hostages122311693hostage_s
jotters143413803jott__ers
lotters73921063lott__ers
montages111412183montage_s
mortgagers1442233mortgagers
mottlers10388183mott_lers
onagers838103_o_nagers
ottars64112223_otta__rs
otters64021513_ott__ers
outages82317323_outage_s
plottages1244243plottage_s
portages112613223portage_s
postages112815323postage_s
potages102416423po_tage_s
pottage103310603pottage__
potterers11218653potterers
potters94024343pott__ers
rootages939093rootage_s
rotters74421393rott__ers
socagers1196363so_cagers
stagers84116673__stagers
totterers9186813totterers
totters74618733tott__ers
upstagers12173333upstagers
vintagers13123893vintagers
voltages1237253voltage_s
voyagers1532813vo_yagers
wattages12106783wattage_s

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641886.26623721.8
3Display Results88880.0302933.3
 (SQL Overall)178691886.45227695.4
 
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.