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

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

60 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
vivisectionists237152(None) 
vivisectionist2261731vivisectionist_
vivisections2052713vivisection___s
divisionists1653274divis___ionists
vivisection1952704vivisection____
vivisectional2162104vivisection__al
deviationists17104745devi__ationists
diversionists1763255div__ersionists
divisionisms1862775divis___ionisms
divisionist1554635divis___ionist_
fictionists1655995__fi__ctionists
perfectionists2164015_perfectionists
projectionists2594115_projectionists
protectionists18105145_protectionists
revisionists15144805revis___ionists
selectionists1556025__selectionists
vivisecting2051965vivisecti_n___g
vivisectors1951755vivisect_o___rs
abstractionists19143306abstractionists
bisections14136736__bisection___s
creationists1476626___creationists
destructionists1894226destructionists
deviationisms1953886devi__ationisms
deviationist1656156devi__ationist_
devolutionists18144416dev_olutionists
dissections14198266di_ssection___s
disunionists1352876__dis_unionists
diversionist1654516div__ersionist_
divisionism1753206divis___ionis_m
evolutionists16145716_ev_olutionists
exhibitionists2662516exhi_bitionists
fictionist1558026__fi__ctionist_
impressionists1862896_impressionists
inflationists1653846_i_nflationists
intuitionists1363896_i_ntuitionists
isolationists1384656_i_solationists
liberationists16143696li_berationists
metafictionists2291816metafictionists
midsections1644406mi_dsection___s
obstructionists19103386obstructionists
oppositionists18132866oppos_itionists
perfectionisms2363296_perfectionisms
perfectionist2055336_perfectionist_
projectionist2485256_projectionist_
protectionisms2094026_protectionisms
protectionist17116686_protectionist_
receptionists1754776__receptionists
recreationists1664376_recreationists
reductionists1654656__reductionists
restrictionists1764086restrictionists
revisionisms17143866revis___ionisms
revisionist14146526revis___ionist_
revolutionists17145126rev_olutionists
selectionist1458086__selectionist_
trisections1345646_trisection___s
vacationists1754586__v_acationists
venesections1752936venesection___s
vivifications2486126vivification___s
vivisector1851646vivisect_o____r
vivisects1742086vivisec______ts

Search took 8 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 Filter178691950240.360496363.9
2DLD Change Limit95024606.89013791.6
3Display Results60600.0461304.3
 (SQL Overall)178691607.29624491.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.