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

133 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
revisals113681(None) 
devisals1245611devisals
revisal1038261revisal_
revivals1435431revivals
devisal1136912devisal_
recitals1039762recitals
recusals1056392recusals
redials84416882redi_als
refusals1164912refusals
reposals1037402reposals
reprisals1144562reprisals
retinals85612962retinals
reveals103812722rev_eals
reversals1245202reversals
reviewals1542962reviewals
revisable1437992revisable
revisers113511932revisers
revises104220532revis_es
revisits1137422revisits
revisors11379062revisors
revival1337032revival_
aerials74017553aeri_als
decimals1345863decimals
denials84114133deni_als
deposals1145433deposals
despisals1243503despisals
devils104412813devi__ls
devisable1546853devisable
devisees12358283devisees
devisers12339863devisers
devises114116763devis_es
devisors12347253devisors
ervils948773ervi__ls
evils84114263_evi__ls
fecials123510333feci_als
fetials103711743feti_als
gavials1136603gavi_als
genitals937243genitals
gremials1136133gremi_als
kevils13358333kevi__ls
medials103914733medi_als
medicals1349363medicals
menials94015683meni_als
meticals12310763meticals
ovisacs1263283_ovisacs
perusals1047143perusals
previses133814283previs_es
previsits1446793previsits
previsors14126483previsors
radials83614643radi_als
radicals112610163radicals
ravishes1478043ravishes
reals55038653re___als
reassails945293reassails
rebills93510623rebi_lls
recital9412163recital_
recoals94214623re_coals
recusal968673recusal_
redial74923113redi_al_
redias74523603redi_a_s
refills103711423refi_lls
refusal1056893refusal_
refutals1165503refutals
reginal84814293reginal_
reginas85614063regina_s
regionals10286413regionals
regosols944323regosols
relishes11311953relishes
relists73817053relis_ts
remises93423483remis_es
remiss84216353remis__s
remissly1344593remissly
remittals1144883remittals
removals1345643removals
renewals1137273renewals
rentals74017473re_ntals
reoils64516873reoi__ls
repeals94014523re_peals
reposal939113reposal_
reprisal1045903reprisal_
requitals1844043requitals
rerises73525883reris_es
resails74616743re__sails
resale64025543re__sale
resales74724903re__sales
resaws93713513re__saws
resays93714153re__says
reseals73917663re_seals
residuals10223803residuals
resists74414923resis_ts
retial64724993reti_al_
retinal75318353retinal_
retinas74819353retina_s
retinols8419743retinols
retotals838463retotals
retrials8510823retrials
reveal94115053rev_eal_
revels94220573rev__els
reversal1145843reversal_
revests104413733reves_ts
revictuals1551993revictuals
reviewal1443513reviewal_
reviews1335533revi_ews
revile94921613revi__le
revilers114011693revilers
reviles104421353revi_les
revise94019743revis__e
revised113815483revis_ed
reviser104114663revis_er
revising122714403revising
revision1138713revision
revisions1238593revisions
revisit10311373revis_it
revisor10388733revis_or
revisory14306013revisory
revitalise13106613revitalise
revivable1736863revivable
revivalism1844123revivalism
revivalist1645203revivalist
revivers14389633revivers
revives134715543revi_ves
revuists1135153revuis_ts
rials55026673r__i_als
rivals94213183r__ivals
riyals94111083r__iyals
serials73919743seri_als
severals1137593severals
sisals63013573__sisals
vials85822383__vi_als
vinals94716483__vinals
visas84317653__visa_s
visuals1036853__visuals
vitals94514303__vitals

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.436409841.7
2DLD Change Limit1461621338.00018270.3
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.49921024.9
 
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.