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

65 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
varietal114561(None) 
parietal1048771parietal
varietals1244441varietals
marital92314182mari_tal
parietals1146862parietals
variety1337742variet_y
acetal84314903_a_cetal
areal55928733_ar_e_al
argental947933_argental
ariel55228973_arie__l
arietta788903_arietta
ariettas847393_ariettas
ariette7312373_ariette
arista6415293_arista_
aristae7312533_aristae
aristas7413523_aristas
arsenal739383_arsenal
artal55525473_ar__tal
barbital1247053barbital
barista9310813barista_
baristas1039723baristas
basipetal1352383basipetal
capital112311523capi_tal
carceral1247193carceral
carinal94318233cari_nal
caritas93316953cari_tas
gametal1037603ga_metal
hartal9415473har__tal
lanital7310913lani_tal
narial6317953nari__al
oriental848483_oriental
ovarial1037613ovari__al
parental10310943parental
parietes10714543parietes
rictal83113183__rictal
sagittal943283sagittal
shrieval1443363shrieval
societal1045723societal
tapetal938273ta_petal
tarletan845543tarletan
vaginal11288403vagi_nal
varia85824203vari__a_
varias95019903vari__as
variate101316433variat_e
variated121211393variated
variates111214983variates
varicella1492993varicella
varied104817863varie__d
variedly1544753variedly
variegate1344103variegate
varier94619353varie__r
variers103712663varie_rs
varies94330873varie__s
varieties1259203varieties
variola1068893variola_
variolar1176343variolar
variolas1168533variolas
varistor1146393varistor
varlet9423503varlet__
varletry1443453varletry
varlets10411573varlet_s
vatical1239983vati_cal
vegetal1156303v_egetal
veritas103012753veri_tas
vital84819673v__i_tal

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.440406115.9
2DLD Change Limit146162656.42022766.7
3Display Results65650.0164062.5
 (SQL Overall)178691656.87625987.6
 
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.