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 “vegetal” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
vegetal115630(None) 
segetal868381segetal
regental948942regental
vegetable1545682vegetable
vegetably1843952vegetably
vegetally1644212vegetally
vegetant1246962vegetant
vegetate1246672vegetate
vegete1039482veget_e
vestal94615572ve_stal
acetal84314903_acetal
argental947933argental
beget85632563beget__
begets96215523beget_s
bimetal1138433bimetal
cental84420963ce_ntal
cereal8315833cere_al
chaetal1238283chaetal
decretal1146353decretal
dental74319173de_ntal
digital937063digital
egal55119433_eg__al
egesta7428653_egesta_
federal1148533federal
festal94213563fe_stal
fetal85623373__fetal
foetal9311883_foetal
gametal1037603gametal
general81010933general
genital849793genital
geta56627443__geta_
getas65421483__getas
hematal1238953hematal
hyetal1236543_hyetal
legal65715943leg__al
meatal84114733me_atal
mental84521603me_ntal
metal75427383__metal
nepeta837893nepeta_
nepetas935943nepetas
pedestal1146403pedestal
pelletal1045733pelletal
peseta8310573peseta_
pesetas938753pesetas
petal76526893__petal
recital9412163recital
rectal84418133re_ctal
refutal1046943refutal
regal65023793reg__al
regear73512743rege_ar
reginal84814293reginal
regnal74812933reg_nal
renewal1038703renewal
rental63922023re_ntal
repeal84718283repe_al
reseal64819643rese_al
retotal739843retotal
reveal94115053reve_al
segmental1265993segmental
septal84513383se_ptal
setal56430903__setal
several1039533several
skeletal1244043skeletal
tapetal938273tapetal
tectal83713253te_ctal
tegmental1275393tegmental
vagal94613633vag__al
vaginal11288403vaginal
varietal1145613varietal
veal76936813v__e_al
vedette1166003vedette
veejay1933703ve_ejay
veena81912323ve_ena_
veenas91410413ve_enas
vegan95114153veg__an
veges94118873vege__s
vegetables1642703vegetables
vegetated1445083vegetated
vegetates1346403vegetates
vegetist1257393vegetist
vegetive1545543vegetive
veinal93812963ve_inal
venal85523213v__enal
venereal1145083venereal
venetian1146073venetian
vengeful1542873vengeful
venial94218283ve_nial
ventail10310453ve_ntail
ventral103612173ventral
verbal112513663ve_rbal
veritas103012753veritas
vernal93514213ve_rnal
versal93013753ve_rsal
vesical12159813vesical
vesperal1344883vesperal
vesta86618303ve_sta_
vestals104612333ve_stals
vestas95916683ve_stas
vestral104111013vestral
veteran1039353veteran
vicegeral1551843vicegeral
vineal94814743vine_al
vital84819673v__ital

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 Limit1340271036.48620664.0
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.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.