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

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

84 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
afforestations206224(None) 
afforestation1962361afforestation_
deforestations1853962deforestations
forestations1546322__forestations
reforestations1754462reforestations
affectations2043433aff__ectations
deforestation1754303deforestation_
forestation1447003__forestation_
reafforestation21101473reafforestation_
reforestation1654573reforestation_
affectation1943844aff__ectation_
affirmations2053234affir__mations
afforesting1852854affores__ti_ng
attestations1244464a__ttestations
autorotations1354554autor_otations
fomentations1746794__fomentations
infestations1546624inf__estations
molestations1475474__molestations
protestations1555814_protestations
restations10315844____restations
workstations1952054__workstations
abbreviations202145025a_bbreviations
acceptations1864505a__cceptations
accreditations19122625a_ccreditations
adorations11310235a_dor___ations
affections1845895aff__e__ctions
affiliations1844185aff__iliations
affirmation1953685affir__mation_
affixations2443855aff___ixations
afforests1543735affores__t___s
aggregations1553845a_ggre_gations
alimentations1594995a_limentations
amortizations2456465a_mortizations
annotations1146885anno___tations
appreciations1964755a_ppreciations
arborizations2447425arbor_izations
argumentations1783275argumentations
assentations1245835a__ssentations
attestation1145185a__ttestation_
augmentations1654125a_ugmentations
autorotation1255015autor_otation_
contestations1547735_contestations
corotations1349765__cor_otations
coruscations1645245__coruscations
defenestrations1993305defenestrations
deformations1846845defor__mations
deportations1548465depor__tations
detestations1347585__detestations
disorientations1683625disorientations
effectuations2151955eff__ectuations
encrustations15123085_encrustations
exhortations2244455exhor__tations
exportations2146655expor__tations
fenestrations1695405__fenestrations
fermentations1856275_fermentations
fetations12511385__f__e_tations
flirtations14104265_flir__tations
floatations1444105_flo__atations
floriations1476915_flor__iations
flotations1366875_flo___tations
fomentation1647715__fomentation_
formations1538205__for__mations
formulations1745635__formulations
fornications1755395__fornications
frustrations1544535__f_rustrations
gestations1139775____gestations
importations16156145impor__tations
incrustations15134285_incrustations
infestation1447045inf__estation_
informations17127035infor__mations
malformations2053075malfor__mations
manifestations1981865manifestations
misorientations1783055misorientations
molestation1365965__molestation_
orientations1246915___orientations
outstations1145345___outstations
protestation1456365_protestation_
reformations1747605refor__mations
reformulations1953555reformulations
reinfestations1793885reinfestations
reorientations1465215_reorientations
restation9316915____restation_
superstations15208145super_stations
workstation1852305__workstation_

Search took 7 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 Filter178691950240.1101624463.6
2DLD Change Limit95024846.50014619.1
3Display Results84840.0601400.0
 (SQL Overall)178691846.67026790.3
 
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.