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

81 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
revegetation1610530(None) 
revegetations17114711revegetations
revegetating1753682revegetating
vegetation1448212__vegetation
regeneration1348193regeneration
relegation11610023releg__ation
renegotiation14113663renegotiation
reregulation1346413reregulation
resegregation1563903resegregation
revegetate1444053revegetat__e
revegetated1643703revegetat_ed
revegetates1553933revegetat_es
revelation13410923rev__elation
reverberation1893883reverberation
vegetations1547323__vegetations
cementation1559704ceme_ntation
deceleration1547174deceleration
degeneration1447284degeneration
delectation1448554dele_ctation
delegation1238884deleg__ation
denegation1249414deneg__ation
deregulation1446084deregulation
desegregation1663814desegregation
detestation1248364dete_station
devastation1546734dev_astation
evagination1546564_evagination
hebetation1557094__hebetation
levigation1447024levig__ation
levitation1349444lev__itation
premeditation1855704premeditation
presentation1448994prese_ntation
reaggregation1653144reaggregation
reannexation1953164reannexation
recantation1349864re_cantation
recitation12315944r__ecitation
recreation12413614re_cre_ation
recuperation1656724recuperation
redecoration1546014redecoration
rededication1646504rededication
redigestion1384154redige_stion
reeducation1445934re_education
reelection12198634re_ele_ction
reevaluation1554484reevaluation
reforestation1654574reforestation
refrigeration1764154refrigeration
refutation1349914r__efutation
regenerations1447144regenerations
regimentation1695434regimentation
regulation11312054r__egulation
regurgitation15143404regurgitation
reinfestation1664254reinfestation
reiteration11412164re_iteration
rejuvenation22123004rejuvenation
relegations1248974releg__ations
reluctation1347964re_luctation
remediation1449214reme_diation
remigration14228914remig_ration
remuneration1446934remuneration
renegotiations15113374renegotiations
reoperation13410904re_operation
reorientation1375594reorientation
repetition1278234r__epetition
replantation1445524replantation
representation16154124representation
reputation12411884r__eputation
reregistration1583134reregistration
reregulations1455714reregulations
resegregations1653694resegregations
reservation1489144rese_rvation
resignation1247474resig_nation
restation9316914r__e_station
revalidation1657944revalidation
revaluation1458144rev_aluation
revelations14410304rev__elations
reverberations19113584reverberations
revocation15410814rev__ocation
vegetarian1454434__vegetarian
vegetating1545704__vegetating
vegetational1653374__vegetational
vegetative1744574__vegetative
veneration13412344__veneration

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 Filter1786911247900.406440125.6
2DLD Change Limit124790817.79616006.9
3Display Results81810.0461760.9
 (SQL Overall)178691818.24821664.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.