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

120 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
averment1331160(None) 
averments1449091averments
abetment1248232abetment
advertent1356582advertent
aperient10715152aperient
ferment12315572_ferment
overlent112715292overlent
overmelt13310712overmelt
overmen12311802overmen_
pavement1549442pave_ment
ravelment1447202ravelment
varment12313242_varment
aberrant1049543aberrant
abetments1346073abetments
abutment1247223abutment
acerbest1245453acerbest
acescent1248013acescent
adherent1247773adher_ent
adornment1246273adornment
aeriest73924053a_eriest
afferent1447983affer_ent
agreement1256453agreement
ailment9314233a_ilment
airmen82612353a_irmen_
aldermen1145043aldermen_
alertest8310173alertest
aliment9316703a_liment
amendment1445463amendment
ament76036543a___ment
amercement1645993amercement
apartment1347033apartment
aperients1178253aperients
ardent73022613a__rdent
argent74023663a__rgent
argument1158903argument
armament1249633armament
armet76739453a__rme_t
arpent84822093a__rpent
augment10910203a_ugment
averred11237593averre_d
averring12239063averring
averse95811183averse__
aversely1444853aversely
avert86029493aver___t
averted112211613averte_d
averter102410553averte_r
averters11249513averters
averting122512733averting
avirulent1243633avirulent
axemen1547493axe_men_
basement12311493base_ment
casement12311953case_ment
cavemen1437143cave_men_
cement103321663_ce_ment
cerement12315133_cerement
cermet10321153_cerme_t
clement11313773cle_ment
deferment151210303deferment
dement93825143_de_ment
determent121312903determent
divergent1447363divergent
easement10414163ease_ment
element9317803ele_ment
emergent1149113emergent
everymen1644423everymen_
ferments13311473_ferments
fervent13310063_fervent
garment10315233_garment
gerent73223093_ger_ent
germen9612313_germen_
germens1078623_germens
government1645643government
interment11419223interment
mermen10813813_mermen_
movement1549433move_ment
overbeat132713833overbeat
overbet122716063overbe_t
overeat102620323over_eat
overheat142413773overheat
overhunt14208663overhunt
overlend122510103overlend
overlet102619033overle_t
overman12311463overman_
overmans13310313overmans
overmany1647143overmany
overmeek1735493overmeek
overmelts1447263overmelts
overmine13313663overmine
overneat112713643overneat
overpert13312993overpert
overset102821473overse_t
overspent1449923overspent
overwet132013933overwe_t
pavements1647003pave_ments
percent113520603_percent
permeant12310913_permeant
perpent112318803_perpent
ravelments1545193ravelments
rerent63832453_rer_ent
revelment1448773revelment
reverent112615093rever_ent
revetment1448323revetment
sarment9318763_sarment
segment10312563_segment
serpent92916283_serpent
torment9316173_torment
varments1339063_varments
varmint12311683_varmint
vehement1647763_vehement
verbena1235373_verbena
verdant11313293_verdant
veriest103719133_veriest
vermeil1285223_vermeil
vermes115019143_verme_s
vermin113414523_vermin_
versant10313833_versant
verset94327323_verse_t
vervet124619063_verve_t
vestment13109203_vestment
watermen1377613watermen_

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.1731032896.0
2DLD Change Limit1461621208.28017652.4
3Display Results1201200.0631904.8
 (SQL Overall)1786911208.51620983.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.