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

91 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
revivalists175356(None) 
revivalisms1953551revivalisms
revivalist1645201revivalist_
recitalists1346502recitalists
revitalises14115972revitalises
revivalism1844122revivalis_m
revivalistic2052662revivalistic
aerialists1089523aeri_alists
medievalists1852153medievalists
racialists1247703raci_alists
realists83014843re___alists
recitalist1248983recitalist_
regionalists1355813regionalists
revitalise13106613revitalis_e
revitalised15104943revitalised
revitalizes23117693revitalizes
revivals1435433revival___s
serialists10810363seri_alists
survivalists1851983survivalists
trivialists1464543trivi_alists
vitalists1239223__vitalists
aerialist9914264aeri_alist_
animalists1258244_animalists
aviarists1246614_avi_arists
capitalists1555534capitalists
cembalists1645244ce_mbalists
centralists1348144centralists
clericalists16124154clericalists
devitalizes24107104devitalizes
dialists9411414__di_alists
federalists1544754federalists
feudalists1454574fe_udalists
finalists123010164__finalists
generalists12136944generalists
herbalists1546194he_rbalists
legalists1047944le__galists
maximalists2253104maximalists
medalists1249374me__dalists
medievalisms2052184medievalisms
medievalist1752894medievalist_
mentalists12410484me_ntalists
metalists11412664me__talists
minimalists15114604minimalists
neorealists1165284neorealists
neutralists11116644neutralists
nominalists1355734nominalists
privatists15176054_privatists
racialisms1447224raci_alisms
racialist11411204raci_alist_
radicalises1445584radicalises
radicalisms1644874radicalisms
rationalists121910064rationalists
realises82420184re___alises
realisms102212164re___alisms
realist73225384re___alist_
recidivists1792424recidivists
reenlists946264re__enlists
regionalisms1555064regionalisms
regionalist1257224regionalist_
relists73817054re____lists
revanchists1952214revanchists
revisals1136814revisal___s
revisionists15144804revisionists
revisits1137424revi__si_ts
revitalising1654664revitalising
revitalize22108274revitali_ze
revitalized24117584revitalized
revival1337034revival____
revivifies1944554revivifi_es
revuists1135154re__v_uists
ritualists1046174r_itualists
royalists12178114r__oyalists
ruralists947644r__uralists
seminarists1375394seminarists
sensualists1154474sensualists
serialises10811564seri_alises
serialisms12610274seri_alisms
serialist9715114seri_alist_
socialists1248494soci_alists
specialists1546204speci_alists
survivalist1752444survivalist_
tribalists1286944_tribalists
trivialises1484684trivi_alises
trivialist1366074trivi_alist_
verbalists1546154ve_rbalists
violists1137664__vi_olists
visualists1344894__visualists
vitalises12310094__vitalises
vitalisms1448514__vitalisms
vitalist11313394__vitalist_
vocalists14108894__vocalists

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit148819919.00016535.4
3Display Results91910.0501820.0
 (SQL Overall)178691919.45618897.1
 
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.