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 “depilations” 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
depilations1431090(None) 
depilation13312031depilation_
epilations12311711_epilations
dealations11311372de_alations
decimations16410162decimations
dedications15310872dedications
deflations1439712de_flations
delations102616592de__lations
depictions1546892depi_ctions
depilating1439192depilati_ng
depilators1347332depilat_ors
depletions1355742dep_letions
deprivations1897922deprivations
deputations1448342deputations
derivations15611492derivations
desolations12310592desolations
deviations14311162devi_ations
dilations102614452d__ilations
epilation11312962_epilation_
aspirations1348993aspirations
capitations1549853capitations
compilations1848683compilations
copulations151111113copulations
crepitations1647473crepitations
deaerations12311673deaerations
dealation10313003de_alation_
deaminations151010133deaminations
debilitations1647133debilitations
decapitations1847663decapitations
decillions1345433decil_lions
decimation15411623decimation_
declinations15410223declinations
decollations1547363decollations
decorations14312883decorations
dedication14311963dedication_
defalcations1845193defalcations
defamations1745893defamations
defecations1779003defecations
definitions1545603definitions
deflation13310653de_flation_
defoliations1647593defoliations
deifications18410653deifications
delation92318083de__lation_
delegations1348033delegations
deletions102610933de__letions
delineations1346763delineations
demolitions1446523demolitions
denegations1348543denegations
denigrations1447353denigrations
denotations1239853denotations
dentations11413633de_ntations
denudations1346343denudations
deoxidations2145243deoxidations
depiction1437273depi_ction_
depilates12310923depilat__es
depilator1247653depilat_o_r
depilatory1645743depilat_ory
depletion1256663dep_letion_
depopulations1844493depopulations
deportations1548463deportations
depositions14117683depositions
depravations1885373depravations
deprecations1748563deprecations
depredations1646733depredations
deprivation1788773deprivation_
deputation1339393deputation_
deputizations2546743deputizations
derivation14712783derivation_
derogations1349393derogations
desiccations1755653desiccations
designations1456943designations
desolation11311403desolation_
desperations1559523desperations
despoliations1646393despoliations
destinations13412663destinations
detonations1239373detonations
devaluations1646353devaluations
deviation13312393devi_ation_
devolutions15106263devolutions
dilation92215463d__ilation_
dilutions10248583d__ilutions
divinations15128413divinations
dominations14611043dominations
dubitations1456673dubitations
duplications1746283duplications
elations83719123_e__lations
emulations12310943_emulations
epilating12310973_epilati_ng
epilators1149433_epilat_ors
etiolations1147393_etiolations
expiations1959663expi_ations
expirations2069583expirations
fellations1338063fe_llations
gelations102513093ge__lations
geminations14139263geminations
hesitations1448543hesitations
jubilations2045363jubilations
legislations1343753legislations
levigations1546213levigations
levitations1448293levitations
mediations13310983medi_ations
medications1649933medications
meditations1449333meditations
mutilations1348643mutilations
peculations15310283peculations
pixilations2045333pixilations
populations15148713populations
recitations13314203recitations
reflations13311233re_flations
regulations12310713regulations
relations92418333re__lations
reparations13611663reparations
repletions1247473rep_letions
replications16811053replications
reputations13410733reputations
respirations14410303respirations
revelations14410303revelations
separations1369273separations
seriations10316683seri_ations
sibilations13127933sibilations
supinations1348833supinations
trepidations1554933trepidations
ventilations1547403ventilations

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331235.08023943.5
3Display Results1231230.0761618.4
 (SQL Overall)1786911235.54632219.8
 
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.