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

106 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
basement1231149(None) 
abasement1348331abasement
basemen1139081basemen_
basements1348261basements
casement12311951casement
easement10414161easement
abasements1446532abasements
abashment1646022abashment
abatement1348182abatement
bailment1249182bailment
bakemeat1655272bakemeat
baseman1138552baseman_
battement1357772battement
besetment1346952besetment
blastment1347162blastment
bodement13410122bodement
casements1348582casements
debasement1547282debasement
easements11410332easements
pavement1549442pavement
abashments1744533abashments
abatements1446353abatements
abetment1248233abetment
absent84016993abs__ent
abutment1247223abutment
ailment9314233_ailment
aliment9316703_aliment
amassment1346413amassment
amazement2246473amazement
ament76036543_a__ment
amusement1347753amusement
ascent84519653_as_cent
ashmen1168173_ashmen_
assent65119953_as_sent
augment10910203_augment
averment13311603_averment
axemen1547493_axemen_
babblement1554133babblement
badmen114613833ba_dmen_
bafflement2074163bafflement
bagmen115412533ba_gmen_
bailments1346463bailments
bakemeats1743143bakemeats
baleen8613053bale_en_
baleens938473bale_ens
banishment1775973banishment
bargemen1346403bargemen_
barmen105418533ba_rmen_
baseless1099563baseless
baseline10310753baseline
baseness10910943baseness
basest84720493bas__est
basilect1245903basilect
basinet9318933basine_t
basket125722913bas_ke_t
basset85225383bas_se_t
bassett94213863bas_sett
bassinet10312843bassinet
batmen104414303ba_tmen_
batsmen1146883batsmen_
battements1455813battements
battlement1446093battlement
baymen134212003ba_ymen_
bedemen12910183bedemen_
bemusement1645143bemusement
besetments1445293besetments
besprent1248033besprent
blastments1444973blastments
bodements1447613bodements
brakemen1644843brakemen_
bushmen1436303bushmen_
busmen1039893bus_men_
cavemen1437143cavemen_
cement103321663__cement
cerement12315133cerement
clement11313773_clement
debasements1666173debasements
debatement1547063debatement
dement93825143__dement
element9317803_element
encasement1448693encasement
garment10315233ga_rment
gasmen93111563gas_men_
gatemen1047603gatemen_
lament85024943la__ment
misevent1349223misevent
movement1549433movement
nascent9610523nas_cent
parament12415393parament
pavements1647003pavements
payment14310703pa_yment
placement1548183placement
raiment9315413ra_iment
ravelment1447203ravelment
recement12315653recement
rousement1149033rousement
sarment9318763sa_rment
segment10312563__segment
semen75724103__semen_
semens84616963__semens
statement1148783statement
subbasement1753093subbasement
tenement10412593tenement
varment12313243va_rment
vehement1647763vehement
vestment13109203vestment

Search took 10 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 Limit1461621069.40615539.2
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.60818598.1
 
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.