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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
revictualling196114(None) 
revictualing1851871revictua_ling
victualling1752182__victualling
revictualled1871263revictuall_ed
victualing1643403__victua_ling
recalling122211904re__c__alling
redialling1246204redi___alling
redictating1546804redict_a_ting
redistilling1453304redist_illing
reinstalling1373394re_installing
resituating1247544resi_tua_ting
reticulating1546394retic_ulating
retotalling1244044re_tot_alling
revictual1442694revictua_l___
revictualed1751484revictua_l_ed
revictuals1551994revictua_l__s
revitalising1654664revi_t_alising
revitalizing2546624revi_t_alizing
credentialling18121535credentialling
devilling1436705devi____lling
devitalizing2645945devi_t_alizing
equalling1945245_e___qualling
evacuating1645675_evac_ua_ting
eventuating1543255_eventua_ting
evicting1437485_evict____ing
initialling1252795_ini_tialling
levitating1446655levi_t_a_ting
metalling1249595me___t_alling
overcalling1747325overc__alling
pedestalling1652565pedest_alling
presignalling1761115presi_gnalling
rebilling12228835rebi____lling
recirculating1853535recirculating
recoaling121312455re__c_oa_ling
recoupling1545045re__cou_pling
redialing11311845redi___a_ling
refalling132010425re____falling
refilling13299335refi____lling
refuelling1474975re___fuelling
reluctating1445765reluct_a_ting
rescaling122212015re_sc__a_ling
restabling1337655re__st_abling
retailing103214735re___t_ailing
retallying1464705re___t_allying
retelling102112495re___t_elling
retitling1039775reti_t___ling
retotaling1186885re_tot_a_ling
revaluating1545895rev_alua_ting
revaluing1337305rev____aluing
revealing132611885rev___ea_ling
revelling132412555rev____elling
revibrating1745575revi_bra_ting
reviling122917215revi_____ling
reviolating1556255revi_ola_ting
revitalise13106615revi_t_a_lise
revitalize22108275revi_t_a_lize
ridiculing1442485ridic_u__ling
ritualizing2156815r__i_tualizing
rivalling1335965r__i__valling
teetotalling1351865teetot_alling
vesiculating1844665vesic_ulating
vialling1237225__vi___alling
victualled1652155__victuall_ed
victualler1551925__victuall_er
victuallers1651335__victuallers

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.390458182.1
2DLD Change Limit124790657.95315690.9
3Display Results65650.0461413.0
 (SQL Overall)178691658.38921300.6
 
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.