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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
revalidating174418(None) 
invalidating1793442invalidating
retaliating1248872retali_ating
revalidation1657942revalidation
revalidations1747112revalidations
revaluating1545892reval_uating
validating1545842__validating
desalinating1476313desalinating
devaluating1645053deval_uating
evaginating1644913_evaginating
evaluating1456023_eval_uating
prevaricating2153073prevaricating
reanimating1447233re_animating
recalibrating1852963recalibrating
reevaluating1653353reeval_uating
replicating1649093re_plicating
reradiating1347263reradi_ating
revaccinating2152703revaccinating
revalidate1454703revalidat__e
revalidated1654223revalidat_ed
revalidates1554363revalidat_es
deaminating1547974de_aminating
debilitating1654114debilitating
decapitating1854954decapitating
defalcating1844344defal_cating
defoliating1645824defoli_ating
delaminating1645684delaminating
deracinating1645224deracinating
devastating1644704deva_stating
deviating14311084dev__i_ating
dilapidating1762024dilapidating
divaricating1953594divaricating
elucidating1543694_elucidating
emaciating1546824_emaci_ating
eradiating1248734_eradi_ating
eradicating1556634_eradicating
evacuating1645684_eva_cuating
evaporating1744194_evaporating
explicating2356124_explicating
invaginating1753904invaginating
invalidation1646044invalidation
invalidations1745624invalidations
invaliding1544704invalid__ing
lapidating1445244__lapidating
levigating1545694lev__igating
levitating1446654lev__itating
radiating111112134r__adi_ating
radicating1459074r__adicating
reactivating1844754reactivating
readapting1445154re_a__dapting
readdicting1643814re_addicting
realigning1245934re_ali_gning
realising10313174re_ali__sing
realization20417224re_alization
realizations21415534re_alizations
realizing19313814re_ali__zing
reallocating1573664reallocating
reallotting1243674re_allotting
rebaiting12311644reba_i__ting
recalculating1853644recalculating
recultivating1953014recultivating
redating102620174re____dating
rededicating1744334rededicating
reduplicating1953504reduplicating
reelevating1544964re_elevating
reenlisting1244674reenli_sting
reestimating1545934reestimating
reflating132514714re_fl__ating
refloating14198324re_fl_oating
regelating1239954regel__ating
regulating12310064regul__ating
rehabilitating2061854rehabilitating
relating92725444re__l__ating
relegating1239484re__legating
relighting1545854re__lighting
relisting102414354re__li_sting
relocating13310874re__locating
remediating1547134remedi_ating
remotivating1864334remotivating
renominating1546424renominating
repainting13128974repa_i_nting
repatriating1545454repatriating
replating122217404re_pl__ating
repudiating1546204repudi_ating
resaluting1137394resal__uting
resinating11313734re__sinating
reslating102516994re_sl__ating
resplitting1444944respli_tting
retaliation11612324retali_ation
retaliations12511404retali_ations
retaliative1454984retali_ative
revalorizing2553834revalorizing
revaluation1458144reval_uation
revaluations1557634reval_uations
revaluing1337304reval___uing
revegetating1753684revegetating
revibrating1745574rev_ibrating
reviolating1556264rev_iolating
revisiting1446954rev__isiting
revolting1339634revol___ting
salivating1447444__salivating
sealifting1444634se_ali_fting
validation1448414__validation
validations1547244__validations
valuating1338654__val_uating
variating13310954__vari_ating
vellicating1744564ve_llicating

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901077.12617511.9
3Display Results1071070.0761407.9
 (SQL Overall)1786911077.59223536.7
 
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.