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

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

82 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
ravishments195410(None) 
ravishment1855121ravishment_
banishments1864292banishments
famishments2153382famishments
abashments1744533_abashments
advisements1754823advisements
banishment1775973banishment_
famishment2054543famishment_
garnishments1873333garnishments
punishments1853443punishments
raiments1039903ra_i__ments
ravagements1754163ravagements
ravelments1545193rav_elments
ravishers1564773ravish_e_rs
ravishes1478043ravish_e__s
revilements1647133revilements
abasements1446534_abasements
abashment1646024_abashment_
abolishments1993544abolishments
advisement1645644advisement_
ailments1039434_a_i_lments
alightments1792764_alightments
alignments1344634_alignments
aliments10311094_ali__ments
alinements1247134_alinements
amassments1444494_amassments
ambushments2063694ambushments
amusements1446234_amusements
arrestments1354694arrestments
averments1449094_av_erments
avouchments2152714_avouchments
bailments1346464ba_i_lments
basements1348264ba__sements
blandishments21102334blandishments
casements1348584ca__sements
catchments1944454ca_tchments
devilments1646384devi_lments
divestments17155164divestments
easements11410334ea__sements
encashments1875064encashments
enlistments1345664enlistments
enmeshments1854364enmeshments
enrichments1855334enrichments
fleshments1843854_fleshments
garnishment1774374garnishment_
habiliments1852554habiliments
harassments1653434harassments
hatchments2043884ha_tchments
investments1665904investments
languishments1962274languishments
lavishers1564644lavish_e_rs
lavishes1457404lavish_e__s
lavishest1554884lavish_est_
lavishness1644714lavishne_ss
nourishments1753694nourishments
parchments1944984pa_rchments
pavements1647004pav__ements
punishment1754544punishment_
rabblements1753634rabblements
radishes1269464radish_e__s
raiment9315414ra_i__ment_
rakishness1744614rakishne_ss
ravagement1644984ravagement_
ravelment1447204rav_elment_
ravished1555714ravish_e__d
ravisher1465454ravish_e__r
ravishing1634984ravish_in_g
realignments1553284realignments
refinements1646794refinements
refreshments2053604refreshments
regiments123910324regi__ments
remitments1446844remi_tments
repigments1546344repi_gments
retirements1357614retirements
revealments1644494revealments
revelments1546864rev_elments
revetments1546434rev_etments
revilement1548484revilement_
rousements1247324r_ousements
rudiments1245824rudi__ments
stablishments20132494stablishments
vestments1486814__vestments

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 Filter1786911488190.1701051123.5
2DLD Change Limit148819829.26616060.8
3Display Results82820.0801025.0
 (SQL Overall)178691829.51618778.0
 
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.