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

144 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
warrener113691(None) 
barrener1038331barrener
warreners1236191warreners
careener1039322careener
darkener1335992darkener
gardener1037102gardener
hardener1238882hardener
harkener1537572harkener
larcener1036492larcener
parcener1238462parcener
wakener1446912wa_kener
warner93717222wa_r_ner
warranter1245192warranter
warren95012852warren__
warrens103810892warren_s
aliener71011193_aliener
arene55329413_a_rene_
arenes64928393_a_renes
arranger936873_arranger
arrayer10136703_arrayer
arrear6310253_arre_ar
arrester839253_arrester
arriver10117793_arriver
awakener1543433awakener
barrater10310143barrater
barreled1137843barreled
barren85317613barren__
barrenest1149563barrenest
barrenly1345413barrenly
barrens94414323barren_s
barretor1046713barretor
barrier94017733barr_ier
bartender1244603bartender
barterer102711633barterer
battener10369393battener
burdener1136133burdener
careened1139193careened
careeners1138533careeners
career85822243ca_re_er
careerer1038583careerer
carpenter1346493carpenter
carrier93619583carr_ier
dampener1335533dampener
darkened1435943darkened
darkeners1435153darkeners
darneder1033983darneder
darner74017303da_r_ner
earner63617223ea_r_ner
farrier103514883farr_ier
fastener11227833fastener
fattener11268113fattener
ferreter1136543ferreter
furriner11267283furriner
gardened1137003gardened
gardeners1136603gardeners
garner73917003ga_r_ner
garreted1057523garreted
garroter956573garroter
greener83111713_greener
hardened1338613hardened
hardeners1338083hardeners
harkened1637483harkened
harkeners1636073harkeners
harrier104417753harr_ier
harrower1446363harrower
hastener11259133hastener
hearkener1644213hearkener
heartener1256763heartener
larceners1135993larceners
larruper1042743larruper
lateener835763lateener
mariner93315993ma_riner
marketer1437383marketer
marrer83716673marr__er
marrier93817523marr_ier
narrater838723narrater
narrower1145063narrower
parceners1337453parceners
pardner10239473pa_rdner
pardoner11189443pardoner
parleyer1335613parleyer
parrier93717653parr_ier
parroter1058203parroter
partner92811393pa_rtner
preener93114833_preener
quarreler1863233quarreler
rattener8238533rattener
ravener104110733ra_vener
sarcenet10413313sarcenet
sarsenet8412943sarsenet
screener1037563screener
serener73415753_serener
sharpener1444583sharpener
surrender1074533surrender
tarrier74323173tarr_ier
taverner1134423taverner
terrene72411033terrene_
terrenes82212593terrenes
wagerer11328493wa_gerer
waggoner1343413waggoner
wagoner1136083wa_goner
wakened1546873wa_kened
wakeners1535843wa_keners
wanderer122210123wanderer
wanner94019623wa__nner
wantoner1187553wantoner
warbler123211463wa_rbler
warden104515513warden__
wardenry1542973wardenry
wardens113711903warden_s
warder104020273wa_r_der
warier93722893wa_r_ier
warmaker1735973warmaker
warmer113816733wa_r_mer
warmonger1543853warmonger
warned104018913wa_r_ned
warners103315563wa_r_ners
warper114015583wa_r_per
warpower1645043warpower
warrant10614243warran_t
warranted1345013warranted
warrantee1245273warrantee
warranters1344523warranters
warrantor1243213warrantor
warrants1168503warrants
warranty1465043warranty
warred104019843warr__ed
warring113717973warrin_g
warrior1045363warr_ior
warsler10289893wa_rsler
warstler11275933warstler
wartier103413913wa_rtier
waterer103314073wa_terer
waterier11312083waterier
waverer13319523wa_verer
weakener1534913weakener
wherever1743823wherever
whitener1435733whitener
widener11318693w_idener
wiener94513543w__iener
woodener1245763woodener
worrier102311673worr_ier
worsened1236053worsened
yarner93313063ya_r_ner

Search took 9 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.1561145455.1
2DLD Change Limit1461621448.14017956.0
3Display Results1441440.0463130.4
 (SQL Overall)1786911448.34221420.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.