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

68 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
varistor114639(None) 
varistors1246531varistors
aristo6414032_aristo_
aristos7312372_aristos
varactor1345682varactor
alastor739653_alastor
arista6415293_arist_a
aristae7312533_aristae
aristas7413523_aristas
arrestor847653arrestor
assistor844823assistor
aviator10229663_aviator
banister10199973banister
barista9310813barist_a
baristas1039723baristas
barnstorm1343943barnstorm
barrator1048403barrator
barretor1046713barretor
barrister1145733barrister
bristol937043_bristol
canister101710853canister
castor84418533ca__stor
ganister9178993ganister
grister83915413_grister
heritor10310563heri_tor
janitor1436483jani_tor
lamister1037653lamister
magister1136283magister
narrator847563narrator
pastor84817483pa__stor
radiator949203radiator
resistor847673resistor
sartor6313883sar__tor
thrustor1144123thrustor
thyristor1542363thyristor
traitor7310123trai_tor
trustor7238413_trustor
valuator1196723valuator
vanisher14167453vanisher
vanitory1445733vani_tory
varactors1446393varactors
variate101316433variat_e
variated121211393variated
variates111214983variates
variation12312393variation
variegator1452653variegator
varier94619353vari__er
varietal1145613varietal
variety1337743variet_y
variform1645003vari_form
variolar1176343variolar
varnisher15195403varnisher
varsity1356673varsit_y
vaster94521023va__ster
vavasor13143603vavas_or
vavassor1441723vavassor
verismo12276393verismo_
verismos13284693verismos
verist93823893verist__
veristic1339883veristic
verists103613673verist_s
viator93211833v__iator
victor113210673v__ictor
visitor1046203v__isitor
visor82512833v__is_or
vitiator1147043vitiator
waister103812383wa_ister
warison1037083waris_on

Search took 7 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 Limit146162686.51622431.2
3Display Results68680.0164250.0
 (SQL Overall)178691686.93825755.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.