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

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
warreners123619(None) 
warrener1136911warrener_
barrener1038332barrener_
careeners1138542careeners
darkeners1435152darkeners
gardeners1136602gardeners
hardeners1338082hardeners
harkeners1636072harkeners
larceners1135992larceners
parceners1337452parceners
wakeners1535842wa_keners
warners103315562wa_r_ners
warranters1344532warranters
warrens103810892warren__s
alieners889823_alieners
arenes64928393_a_rene_s
arrangers1045823_arrangers
arrayers11125853_arrayers
arrears738843_arre_ars
arresters948193_arresters
arrivers11137003_arrivers
awakeners1643093awakeners
awareness1236343awareness
bareness10912813ba_reness
barraters1138043barraters
barrenest1149563barrenest
barrenness1243753barrenness
barrens94414323barren__s
barretors1146243barretors
barriers104311883barr_iers
bartenders1344223bartenders
barterers11269633barterers
batteners11238163batteners
burdeners1245063burdeners
careener1039333careener_
careerers1137243careerers
careers95218783ca_re_ers
carpenters1445843carpenters
carriers103614203carr_iers
dampeners1444663dampeners
darkener1335993darkener_
darners83815773da_r_ners
earners74016453ea_r_ners
farriers113610743farr_iers
fasteners12237053fasteners
fatteners12236873fatteners
ferreters1246253ferreters
furriners12316323furriners
gardener1037103gardener_
garners83815983ga_r_ners
garroters1055813garroters
hardener1238883hardener_
harkener1537573harkener_
harriers113712433harr_iers
harrowers1555683harrowers
hasteners12267813hasteners
hearkeners1743983hearkeners
hearteners1346213hearteners
larcener1036493larcener_
largeness1038273largeness
larrupers1142523larrupers
lateeners945563lateeners
mariners103113863ma_riners
marketers1545983marketers
marrers93414313marr__ers
marriers103312473marr_iers
narraters946703narraters
parcener1238473parcener_
pardners11269193pa_rdners
pardoners12208213pardoners
parleyers1444703parleyers
parriers103612903parr_iers
parroters1156763parroters
partners102711133pa_rtners
preeners102712813_preeners
quarrelers1962763quarrelers
rareness81112853ra_reness
ratteners9237263ratteners
raveners11309133ra_veners
sarcenets1146953sarcenets
sarsenets946513sarsenets
screeners1136733screeners
sharpeners1543893sharpeners
surrenders1174153surrenders
tarriers83411713tarr_iers
tarriness9229243tarriness
taverners1244273taverners
terrenes82212603terrene_s
waeness102512783wa__eness
wagerers12247613wa_gerers
waggoners1443183waggoners
wagoners1235473wa_goners
wakener1446913wa_kener_
wanderers13228483wanderers
wantoners12116673wantoners
warblers13319103wa_rblers
wardenry1542973warden_ry
wardens113711903warden__s
warders113416813wa_r_ders
wariness11313213wa_riness
warmakers1845633warmakers
warmers124514293wa_r_mers
warmness1337063wa_rmness
warmongers1643633warmongers
warner93717223wa_r_ner_
warpers123413583wa_r_pers
warpowers1744553warpowers
warrantees1343443warrantees
warranter1245203warranter_
warrantors1343043warrantors
warrants1168503warran_ts
warren95012853warren___
warriors1135363warr_iors
warslers11328073wa_rslers
warstlers12284713warstlers
waterers112312783wa_terers
waverers14318613wa_verers
weakeners1644163weakeners
whiteners1535243whiteners
wideners12257993w_ideners
wieners103212483w__ieners
worriers11257813worr_iers
yarners104312203ya_r_ners

Search took 8 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.420425454.8
2DLD Change Limit1486411236.91021511.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.37624226.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.