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

199 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
reopened113850(None) 
deepened1235652deepened
opened94311862__opened
reddened1136422reddened
reopen8311572reopen__
reopens939372reopen_s
repented112614982re_pented
repined104918772re_pined
ripened1038202r_ipened
unopened1137022unopened
betokened1643403betokened
cheapened1743783cheapened
coopered133310933coopered
cozened19349183_cozened
crispened1443613crispened
dampened1435623dampened
deadened1137233deadened
deafened1335853deafened
deepener1145183deepener
depend103510923de_pen_d
depended1337983de_pended
deponed113712873de_poned
dovened12389063_dovened
dozened18377453_dozened
eocene8311613_eocene_
evened101010313_e_vened
expend16247503_expen_d
expended19136543_expended
expensed18126413_expensed
eyeopener1452243eyeopener
freshened1645253freshened
greatened1144583greatened
greened93111263gre__ened
happened1635653happened
keened114013623ke__ened
leadened1036153leadened
leavened1235553leavened
lessened935093lessened
lippened13255223lippened
loosened945453loosened
neatened937043neatened
neogene847553neogene_
neoned7311483neo__ned
neoprene1045173neoprene_
neoprenes1145563neoprenes
omened93711003__omened
opener83910993__opener
opined95113853__opined
peened94318153pe__ened
peopled1238483peop_led
peppered1236113peppered
perpend12259333perpen_d
perpended1546063perpended
popeyed1535703_popeyed
preened103214983pre__ened
preowned1435213preo_wned
propend123311273propen_d
propended1546163propended
propene112716043propene_
propenes122816513propenes
propined133111503propined
proponed132412033proponed
rappeled1335003rappeled
rattened9218623rattened
ravened115012283r_avened
reaped94122453reap__ed
reasoned9410733reasoned
reblend1036653reblen_d
reblended1355203reblended
rebreed104611073rebre_ed
recaned102817203re_caned
receded112713043re_ceded
rechewed1735633rechewed
reckoned1546953reckoned
recleaned1236583recleaned
reclined113613603reclined
recoined113614423recoined
recompensed18103943recompensed
reconned113610653reconned
reconvened1645393reconvened
recopied1339843recop_ied
recovered15166733recovered
redeemed1235593redeemed
redenied10511283re_denied
redlined103811233redlined
redonned10297103redonned
reearned948883reearned
reeded84022563re__eded
reefed103816583re__efed
reeked113717643re__eked
reeled74725533re__eled
reeved104118713re__eved
refeed104717623re_fe_ed
refenced1438993re_fenced
refined114720003re_fined
reflexed1975233reflexed
refueled1286573refueled
regained102111243regained
regreened1145553regreened
reheeled1236763reheeled
reigned949213re_igned
reined74425523re__ined
rejoined16318593rejoined
rekeyed1536163re_keyed
relend76116453re_len_d
relented92614943re_lented
relieved12438513relieved
relined85321933re_lined
reloaned939723reloaned
remained112412893remained
remanned11319353remanned
remend95216553re_men_d
remended123010393re_mended
remodeled1344723remodeled
rendered102512263rendered
reneged92010763re_neged
renewed11309993re_newed
renowned1235973renowned
reoffered1643313reoffered
reoiled84316853reo_iled
reopening1248823reopening
reoperated1348143reoperated
reopposed1444333reopposed
reordered1145383reordered
reoriented1145343reoriented
repand95316063re_pan_d
repanel939963re_panel
repapered1445233repapered
repaved133311133re_paved
repealed113211873re_pealed
repeated113117443re_peated
repegged1334883re_pegged
repelled113111573re_pelled
repent84728873re_pen_t
repenter102813863re_penter
repents93717623re_pents
reperked15177793re_perked
repetend1136223re_petend
repine85627813re_pine_
repiner94816903re_piner
repines94927383re_pines
repinned1157473repinned
repled93319773re_p_led
replied103914443re_plied
repolled11359623repolled
reported11312703reported
reposed103616273re_posed
repotted1139283repotted
repoured1139563repoured
repowered1544663repowered
repped114616723re_p_ped
repugned1235353repugned
reputed104613483re_puted
rerented92516163re_rented
reseed74823293re_se_ed
reseeded1038093reseeded
resend75016773re_sen_d
resented92716963re_sented
resewed113011823re_sewed
reshined123011123reshined
resigned1038863resigned
resined84522653re_sined
resoftened1443413resoftened
respaced1338503respaced
respaded1238133respaded
respected1438493respected
respelled1257023respelled
respired1148993respired
respited11410813respited
respond1039113respon_d
responded1336513responded
retained93016093retained
retene69224273re_tene_
retenes76324623re_tenes
retuned86613973re_tuned
returned9459133returned
reveled113917753re_veled
revenged1337553re_venged
revenued1237223re_venued
revered112819333re_vered
reviewed1534823reviewed
rewakened1743443rewakened
rewidened1444073rewidened
rezoned173611163re_zoned
richened1435953richened
ripener937903r_ipener
rodeoed937883r_odeoed
rogered939553r_ogered
roped84630803r_op__ed
rosined84911903r_osined
roweled11269863r_oweled
steepened1244073steepened
tempered13248213tempered
terpene92310853terpene_
terpenes102111563terpenes
tokened1236393_tokened
weakened1634823weakened
weaponed1445493weaponed
weened104013733we__ened

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 Limit1461621998.51317169.3
3Display Results1991990.0802487.5
 (SQL Overall)1786911998.74920424.2
 
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.