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

47 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
vacuolar135348(None) 
facular122810442facu_lar
macular113011942macu_lar
vacuolate1445222vacuolate
vacuole1245372vacuol_e
vacuoles1345012vacuoles
variolar1176342variolar
vascular1346292vascu_lar
alular6311353_alu_lar
areolar779223_areolar
avascular1443733avascu_lar
avicular13237273avicu_lar
bacillar1276533bacillar
bacula103112673bacu_la_
canular9310323canu_lar
escolar946053esc_olar
fabular12288693fabu_lar
facula112912233facu_la_
faculae123210353facu_lae
hamular1236973hamu_lar
jocular1637303jocu_lar
lacunar9136293lacu_nar
locular938953locu_lar
macula103013673macu_la_
maculae113412863macu_lae
maculas113114023macu_las
ocular8610133_ocu_lar
oracular1047533oracu_lar
oscular937933oscu_lar
pabular11259473pabu_lar
papular11299763papu_lar
piacular1246573piacu_lar
radular837833radu_lar
ranular739433ranu_lar
saccular1246893saccular
scholar1236953_scholar
secular92211533secu_lar
tabular9279763tabu_lar
vacua10510463vacu__a_
vacuolated1643973vacuolated
vacuous1237023vacuo_us
valvular1443463valvular
variola1068893variola_
variolas1168533variolas
vascula1245853vascu_la_
venular1037683venu_lar
volar86917413v___olar

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.1561145455.1
2DLD Change Limit146162477.70318974.7
3Display Results47470.0162937.5
 (SQL Overall)178691477.87522690.9
 
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.