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

92 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
effectively255449(None) 
affectively2553971affectively
defectively2345202defectively
effective2076192effective__
effectives21134562effective_s
effectivity25103662effectivity
electively1846382e_lectively
ineffectively2753132ineffectively
perfectively2554832perfectively
reflectively2354812reflectively
adjectively2753633adjectively
affectingly2352403affectingly
affective20135413affective__
affectivity25103253affectivity
afflictively2652183afflictively
effectually2252653effectually
effetely1742693effe_t__ely
effusively2252853eff_usively
festively1845773__festively
fictively2044603__fictively
invectively2255183invectively
objectively2854583objectively
offensively2352763offensively
refractively2354773refractively
respectively2285183respectively
selectively1945353selectively
actively1647064___actively
affectedly2252154affect_edly
assertively1774084assertively
attentively1753864attentively
collectively22114624collectively
connectively2255184connectively
correctively2254864correctively
creatively1846674_creatively
deceptively22104534deceptively
deductively2154284deductively
defective1848004defective__
defectives1945684defective_s
defensively2154154defensively
definitively2253254definitively
deflective1956094deflective__
detractively2154904detractively
digestively1953894digestively
effected1744994effect__e_d
effecter1664774effect__e_r
effecters1764324effect__ers
effecting1845584effecti__ng
effectiveness2455674effectiveness
effectual1752764effect_ual_
ejective2037154e_jective__
ejectives2145444e_jective_s
elective13311004e_lective__
electives1448934e_lective_s
emotively1744404e__motively
emulatively1954514emulatively
erective13311834e_rective__
eruptively1844854e_ruptively
evocatively2253684evocatively
excessively2663644excessively
expensively2654104expensively
extensively2453844extensively
extractively2754534extractively
federatively2253904federatively
fertilely1544274__fertilely
fugitively2053194_fugitively
furtively1844844__furtively
inactively1845314_inactively
inceptively2155244inceptively
inductively2054794inductively
ineffective2273944ineffective__
infective17108974infective__
infectivity2254704infectivity
inventively2045754inventively
perceptively2454514perceptively
perfective2047194perfective__
perfectives2145474perfective_s
perfectivity2563844perfectivity
perspectively2553274perspectively
projectively2953984projectively
protectively2254724protectively
reactively1845884_reactively
receptively2165174receptively
reductively2045164reductively
refective1749114refective__
reflective1857124reflective__
reflectivity2353814reflectivity
reflexively2752164refle_xively
restively1548314__restively
retentively1746084retentively
secretively1954714secre_tively
seductively2054294seductively
subjectively2953564subjectively

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 Filter1786911488190.453394461.4
2DLD Change Limit148819928.25318032.1
3Display Results92920.0601533.3
 (SQL Overall)178691928.76620384.6
 
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.