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

50 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
vivisecting205196(None) 
vivisection1952702vivisection
vivisections2052712vivisections
bisecting1436973__bisecting
dissecting14139473di_ssecting
trisecting1345503_trisecting
vivisect1643783vivisect___
vivisected1951413vivisect_ed
vivisectional2162103vivisectional
vivisector1851643vivisect_or
vivisectors1951753vivisectors
vivisects1742083vivisect__s
advecting1645114adv__ecting
codirecting1743644codirecting
directing1338824__directing
disinfecting1954694disinfecting
disjecting2177244di_sjecting
disseating121111784di_sseating
dissenting121310294di_ssenting
disserting121310854di_sserting
diverting142410334div__erting
divesting14298484div__esting
evicting1437484_evi__cting
exsecting1935934__exsecting
filmsetting1751874filmsetting
infecting15109674_i_nfecting
inflecting1646314_inflecting
injecting1997694_i_njecting
inserting10914244_i_nserting
insetting1079284_i_nsetting
inspecting1546224_inspecting
misacting1439084__misacting
misdirecting1853244misdirecting
miseating121215434__miseating
misseating131310944mi_sseating
missetting13107904mi_ssetting
prosecting15189814_prosecting
redirecting1545614redirecting
resecting122816484__resecting
revisiting1446954revis_iting
riveting12139444riv__e_ting
rivetting13256414riv__etting
transecting1447374transecting
vignetting1542824vi_gnetting
vilipending1851254vilipending
viseing11299164__vise__ing
visiting1238394__vis_iting
vitiating1338414viti__ating
vivifying2243844vivi__fying
vivisectionist2261734vivisectionist

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 Filter1786911488190.423422437.4
2DLD Change Limit148819508.10618359.1
3Display Results50500.0163125.0
 (SQL Overall)178691508.54520911.8
 
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.