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

93 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
revegetating175368(None) 
revegetation16105302revegetation
revegetations17114712revegetations
vegetating1545702__vegetating
redefeating1645333redefe_ating
reelevating1544963re_elevating
regelating1239953r__egelating
regenerating1446333regenerating
relegating1239483releg__ating
renegotiating1552243renegotiating
reregulating1454643reregulating
rerepeating1447183rerepe_ating
resegregating1652843resegregating
revegetate1444053revegetat__e
revegetated1643703revegetat_ed
revegetates1553933revegetat_es
reverberating1953203reverberating
revetting132912633rev__et_ting
begetting13186584__beget_ting
brevetting1644334brev__et_ting
decelerating1645594decelerating
degenerating1545664degenerating
delectating1545994dele_ctating
delegating1337674deleg__ating
deregulating1554014deregulating
desegregating1752734desegregating
devastating1644704dev_astating
evaginating1644904_evaginating
eventuating1543254_eventuating
eyeletting1442874_eyelet_ting
hebetating1645794__hebetating
levigating1545694levig__ating
levitating1446654lev__itating
overeating141016524_overe_ating
overstating15410734_overstating
premeditating1953654premeditating
reaggregating1552564reaggregating
recementing1645224receme_nting
recreating131214584re_cre_ating
recuperating1744994recuperating
redecorating16115044redecorating
rededicating1744334rededicating
redefecting1844374redefe_cting
redictating1546804re_dictating
redigesting1444574redige_sting
reeducating1545164re_educating
reejecting2045814re_eje_cting
reelecting1338784re_ele_cting
reemitting1346634re_emit_ting
reerecting1339974re_ere_cting
reevaluating1653354reevaluating
reexecuting2142544re_executing
refrigerating1853184refrigerating
regearing112211414r__ege_aring
regrating111316214r__eg_rating
regretting1237784re_gret_ting
regulating12310064r__egulating
regurgitating1662204regurgitating
reheating132314914r__ehe_ating
reinstating1248114re_instating
reiterating12410494re_iterating
rejuvenating2352194rejuvenating
reletting102713944r__elet_ting
reluctating1445764re_luctating
remediating1547134reme_diating
remeeting12311434reme_e__ting
remigrating1547594remig_rating
remunerating1545414remunerating
renegading1344594reneg__ading
reoperating1449024re_operating
reorientating1473764reorientating
repeating122618984r__epe_ating
rereleasing1243984rerele_asing
reseating102421534r__ese_ating
reselecting1446024resele_cting
resetting102816294r__eset_ting
restating102319414r__e_stating
retreating111414774re_tre_ating
revalidating1744184revalidating
revaluating1545894rev_aluating
revealing132611884rev__e_aling
reverencing1743834revere_ncing
reverting132315134rev__e_rting
revesting132814124rev__e_sting
revibrating1745574rev_ibrating
reviolating1556244rev_iolating
rewetting132710444r__ewet_ting
rivetting13256414riv__et_ting
vegetation1448214__vegetation
vegetations1547314__vegetations
vegetative1744574__vegetative
venenating1446014__venenating
venerating14410054__venerating

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.1401276364.3
2DLD Change Limit124790937.78016039.8
3Display Results93930.0631476.2
 (SQL Overall)178691937.98322383.9
 
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.