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
varactor134570(None) 
varactors1446411varactors
parachor1546662parachor
tractor9311342_tractor
varistor1146392varistor
abator84512723_aba_tor
actor71116083___actor
adaptor1034953_adaptor
aerator7314843aera_tor
alastor739673_alastor
attractor1145823attractor
aviator10229663avia_tor
barrator1048403barrator
barretor1046713barretor
capacitor1543483capacitor
caracol11310423carac_ol
character1645883character
coactor1139133_coactor
cofactor1545763cofactor
curator9312213cura_tor
detractor12147213detractor
director1147783director
enactor938043_enactor
erector93513813_erector
exactor1636633_exactor
extractor1846723extractor
factor11911463__factor
fractur12135573_fractur
grantor84010943_grantor
guarantor1042643guarantor
gyrator1135723gyra_tor
impactor14265013impactor
infractor1465943infractor
marcato1139743marcato_
marcatos1249163marcatos
narrator847563narrator
nonactor1047783nonactor
orator6314533_ora_tor
oviraptor1441943oviraptor
parachors1647413parachors
parador103311413para_dor
playactor1642093playactor
praetor938973_praetor
proctor11310433_proctor
raptor83912823__raptor
reactor93011663_reactor
rector84019753__rector
redactor1147033redactor
refractor14156323refractor
retractor11218513retractor
sartor6313883sar__tor
tractors10312573_tractors
traitor7310123_traitor
valuator1196733valuator
varistors1246533varistors
vavasor13143603vava_sor
vavassor1441723vavassor
vector113212063v__ector
viator93211833v_ia_tor
vibrator13227343vibra_tor
victor113210673v__ictor
warrantor1243213warrantor

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 Filter1786911461620.423422437.4
2DLD Change Limit146162626.87321266.1
3Display Results62620.0331878.8
 (SQL Overall)178691627.32924381.4
 
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.