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

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

62 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
varactor134568(None) 
varactors1446391varactors
parachor1546652parachor
tractor9311332_tractor
varistor1146392varistor
abator84512713_aba_tor
actor71116073___actor
adaptor1034943_adaptor
aerator7314843aera_tor
alastor739653_alastor
attractor1145823attractor
aviator10229663avia_tor
barrator1048403barrator
barretor1046713barretor
capacitor1543473capacitor
caracol11310423carac_ol
character1645883character
coactor1139123_coactor
cofactor1545753cofactor
curator9312213cura_tor
detractor12147213detractor
director1147783director
enactor938033_enactor
erector93513813_erector
exactor1636623_exactor
extractor1846723extractor
factor11911453__factor
fractur12135563_fractur
grantor84010933_grantor
guarantor1042633guarantor
gyrator1135713gyra_tor
impactor14265003impactor
infractor1465943infractor
marcato1139743marcato_
marcatos1249163marcatos
narrator847563narrator
nonactor1047773nonactor
orator6314533_ora_tor
oviraptor1441943oviraptor
parachors1647403parachors
parador103311413para_dor
playactor1642083playactor
praetor938973_praetor
proctor11310433_proctor
raptor83912823__raptor
reactor93011653_reactor
rector84019753__rector
redactor1147023redactor
refractor14156323refractor
retractor11218513retractor
sartor6313883sar__tor
tractors10312563_tractors
traitor7310123_traitor
valuator1196723valuator
varistors1246533varistors
vavasor13143603vava_sor
vavassor1441723vavassor
vector113212063v__ector
viator93211833v_ia_tor
vibrator13227343vibra_tor
victor113210673v__ictor
warrantor1243213warrantor

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.406440125.6
2DLD Change Limit146162627.58019282.6
3Display Results62620.0163875.0
 (SQL Overall)178691628.00222330.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.