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

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

113 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
revivals143543(None) 
revisals1136811revisals
revival1337031revival_
devisals1245612devisals
recitals1039762recitals
redials84416882redi_als
removals1345642removals
retinals85612962retinals
reveals103812722rev_eals
reviewals1542962reviewals
revisal1038262revisal_
revivable1736862revivable
revivalism1844122revivalism
revivalist1645202revivalist
revivers14389632revivers
revives134715542reviv_es
rivals94213182r__ivals
aerials74017553aeri_als
arrivals1145933arrivals
decimals1345863decimals
denials84114133deni_als
deprivals1543533deprivals
devils104412813devi__ls
devisal1136913devisal_
ervils948773ervi__ls
evils84114263_evi__ls
fecials123510333feci_als
festivals1543373festivals
fetials103711743feti_als
gavials1136603gavi_als
genitals937243genitals
gremials1136133gremi_als
kevils13358333kevi__ls
medials103914733medi_als
medicals1349363medicals
medievals1553353medievals
medivacs1644003medivacs
menials94015683meni_als
meticals12310763meticals
radials83614633radi_als
radicals112610153radicals
reals55038653re___als
reavails1134853re_avails
rebills93510623rebi_lls
recital9412163recital_
recoals94214623re_coals
recusals1056393recusals
redial74923113redi_al_
redias74523603redi_a_s
refills103711423refi_lls
refusals1164913refusals
refutals1165503refutals
reginal84814293reginal_
reginas85614063regina_s
regionals10286413regionals
regives115014213regiv_es
reivers105117083re_ivers
reives95723043re_iv_es
relivable1438513relivable
relives104619443reliv_es
remittals1144883remittals
removal1236733removal_
renewals1137273renewals
rentals74017473re_ntals
reoils64516873reoi__ls
repeals94014523re_peals
reposals1037403reposals
reprievals1542433reprievals
reprisals1144563reprisals
reprovals1444883reprovals
requitals1844043requitals
reseals73917663re_seals
residuals10223803residuals
retial64724993reti_al_
retinal75318353retinal_
retinas74819353retina_s
retinols8419743retinols
retotals838463retotals
retrials8510823retrials
retrievals1342623retrievals
reveal94115053rev_eal_
revels94220573re__vels
reversals1245203reversals
revictuals1551993revictuals
reviewal1443513reviewal_
reviews1335533revi_ews
revile94921613revi__le
revilers114011693revilers
reviles104421353revi_les
revisable1437993revisable
revisers113511933revisers
revises104220533revi_ses
revisits1137423revisits
revisors11379063revisors
revitalise13106613revitalise
revivalisms1953553revivalisms
revivalists1753563revivalists
revive124914823reviv__e
revived144211653reviv_ed
reviver134411373reviv_er
revivify2042923revivify
reviving152910503reviving
rials55026673r__i_als
rival85216503r__ival_
riyals94111083r__iyals
serials73919743seri_als
servals103410743se_rvals
severals1137593severals
survivals1543013survivals
vials85822383__vi_als
vinals94716483__vinals
vitals94514303__vitals
vivas114815023__viva_s

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621138.00018270.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.20221786.3
 
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.