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

53 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
vavasor1314360(None) 
vavasors14153651vavasors
vavasour14142081vavasour
vavassor1441721vavassor
vavasours15131892vavasours
vavassors1541842vavassors
abaser86414343_abaser
abator84512713_abator
advisor11134163advisor
alastor739653_alastor
avast85519363_avas_t
avatar937523_avatar
aviator10229663aviator
aviso85713963_aviso_
avisos95410483_avisos
canvaser13276563canvaser
caveator1387233caveator
devisor11357043devisor
divisor11345573divisor
favas115618593favas__
favor114712453fav__or
havior1248203hav_ior
javas155915423javas__
kavas125919953kavas__
kavass13517303kavas_s
lavabo1135273lavabo_
lavabos1235453lavabos
lavas85422223lavas__
lavash12597373lavas_h
lavatory1445693lavatory
levator10298963levator
matador1066253matador
navar83912733nava__r
parador103311413parador
parasol939553parasol
pavior1138533pav_ior
paviser12489093paviser
ravager1136563ravager
revisor10388733revisor
savager1137133savager
savior9710173sav_ior
savor85417943sav__or
valor83614893__valor
valuator1196723valuator
valvar12388653valva__r
vapor104013093__vapor
varactor1345683varactor
varas86028193varas__
varistor1146393varistor
vavs105720433vav_s__
viator93211833v_iator
visor82512833__visor
vivas114815023vivas__

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 Filter1786911340270.406440125.6
2DLD Change Limit134027536.51620568.9
3Display Results53530.0301766.7
 (SQL Overall)178691536.95225703.5
 
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.