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

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

80 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
reafforestation2110147(None) 
afforestation1962362__afforestation
reforestation1654572re__forestation
afforestations2062243__afforestations
deforestation1754303de__forestation
reforestations1754463re__forestations
deforestations1853964de__forestations
forestation1447004____forestation
reaffirmation2152064reaffir__mation
reafforesting2051394reaffores__ting
reinfestation1664254reinf__estation
affectation1943845__aff__ectation
forestations1546325____forestations
reaccreditation2081185rea_ccreditation
reaffirmations2251975reaffir__mations
reafforest1652835reaffores__t___
reafforested1951215reaffores__t_ed
reafforests1751435reaffores__t__s
reaggregation1653145rea_ggre_gation
reexportation2253145reexpor__tation
reformation1648415re__for__mation
reformulation1853975re__formulation
reimportation17114035reimpor__tation
reinfestations1793885reinf__estations
reorientation1375595re___orientation
affectations2043436__aff__ectations
affirmation1953686__affir__mation
afforesting1852856__affores__ting
attestation1145186__a__ttestation
autorotation1255016__autor_otation
defenestration18173546de__fenestration
defloration1547266de_flor___ation
deformation1747666de__for__mation
deportation1449306de__por__tation
detestation1248366de____testation
differentiation2292116_differentiation
effectuation2052286_e_ff__ectuation
encrustation14103396_e__ncrustation
exhortation2145026_e_xhor__tation
exportation2047446_e_xpor__tation
fomentation1647716____fomentation
infestation1447046__inf__estation
malformation1953326_malfor__mation
manifestation1871996_ma_nifestation
molestation1365966____molestation
perforation1649006pe_rfor___ation
preformation1946476pre__for__mation
protestation1456366___protestation
reaggregations1762846rea_ggre_gations
reallocation1454496reallo___cation
reannexation1953166rea__nne_xation
reapportion1554036reappor____tion
reauthorization2762316reauthor_ization
recomputation1974396re__computation
recordation1449266re__cor__dation
recreation12413616re___cre__ation
redecoration1546016redecor___ation
reexportations2352846reexpor__tations
reforesting1546196re__fores__ting
reformations1747606re__for__mations
reformulations1953556re__formulations
refoundation16102796re__fo_undation
refrigeration1764156re_frige_ration
refutation1349916re__f___utation
regimentation1695436re__gimentation
regurgitation15143406re__gurgitation
reimportations18113596reimpor__tations
reincorporation1962226reincorporation
remonstration15117126re__mo_nstration
reoperation13410906re___ope_ration
reorchestration2072836re_orchestration
reorientations1465216re___orientations
representation16154126re_presentation
resegregation1563906re_segre_gation
restation9316916______restation
restoration11412096re_stor___ation
revalorization2664836revalor_ization
revegetation16105306re__vege_tation
teleportation1552126telepor__tation
workstation1852306____workstation

Search took 8 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.406440125.6
2DLD Change Limit95024806.86013851.9
3Display Results80800.0631269.8
 (SQL Overall)178691807.32924381.4
 
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.