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

166 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
verdures1224775(None) 
perdures11289681perdures
verdure11287771verdure_
verdured13255761verdured
bordures1136172bordures
endures83314602_endures
nervures1135122nervures
ordures856472_ordures
overcures14139992overcures
overdares13310672overdares
overtures121611452overtures
perdues103511332perdu_es
perdure10379622perdure_
perdured12287392perdured
perjures17268082perjures
velures1039092ve_lures
vendues11318622vendu_es
ventures11311492ventures
verderer1245372verderer
verderers1344842verderers
verdurous1343682verdurous
vestures11311042vestures
apertures1146473apertures
armures9510273_armures
bergeres1189113bergeres
bordure1035783bordure_
censures102211623censures
cereuses1049243cereuses
ceruses93716233cer_uses
coendures1245213coendures
covertures1545463covertures
deduces1168793de_duces
dentures9312453dentures
dures65635923___dures
educes94011953_e_duces
endues73813903_endu_es
endure74014143_endure_
endured93611213_endured
endurer83210363_endurer
endurers9317953_endurers
enduros8298153_enduros
ensures73315903_ensures
enures63919713_e_nures
erasures837213_erasures
features11310333features
ferrules1136163ferrules
ferules103112723fer_ules
furfures1445663furfures
gestures9310013gestures
hercules1337633hercules
herders113914123herder_s
lectures101310153lectures
leisures836683leisures
lemures938793le_mures
measures1038913measures
mercuries1347273mercuries
merdes94518603merd__es
nervules1145013nervules
nervure1034973nervure_
nurtures837443nurtures
ordure756813_ordure_
overburns14135613overburns
overcure132210053overcure_
overcured15148643overcured
overdare12311183overdare_
overdared1439163overdared
overdoers13117403overdoers
overdoes121212543overd_oes
overdoses13119793overdoses
overdress1346593overd_ress
overdrew1536233overd_rew
overdries13310883overdries
overdubs1494573overdu_bs
overdue11138953overdu_e_
overdyers16125003overdyers
overdyes15127473overd_yes
overrules12129093overrules
oversure111611163oversure_
overtires121412373overtires
overture111511683overture_
overtured13169213overtured
overturns12136623overturns
overurges1387483over_urges
overuses11312643over_uses
parures9512693par_ures
perdue93912633perdu_e_
perdus93711273perdu__s
perfumes1555893perfumes
perfuses1358663perfuses
perjure16327963perjure_
perjured18286263perjured
perjurer17285903perjurer
perjurers18224463perjurers
perjuries1846493perjuries
permutes1238713permutes
perturbs1244363perturbs
perukes133210113per_ukes
peruses94018163per_uses
precures12312903precures
purpures1276143purpures
reduces10513343re_duces
reroutes8312223reroutes
rondures937713rondures
secures9613163se_cures
seduces1069283se_duces
seisures838273seisures
seizures1744633seizures
tenures7412013te_nures
textures1597523textures
tortures838913tortures
varuses10310623var_uses
veinules1135913veinules
velours10278083velour_s
veloutes1136153veloutes
velure939773ve_lure_
velured1136683ve_lured
vendaces1457183vendaces
vendees114011453vend_ees
venders113717003vender_s
vendeuses1343393vendeuses
vendors113510223vendor_s
vendue10419013vendu_e_
venires103012453ve_nires
venture10311173venture_
ventured1238273ventured
venturer1137243venturer
venturers1245523venturers
venturis1138193venturis
venues95115203ve_nu_es
venules104011483ve_nules
venuses103111413ve_nuses
verbiles1338923verbiles
verderor1243203verderor
verderors1343653verderors
verdicts1446013verdicts
verdigris1441953verdigris
verdins112812333verd_ins
verditer1236223verditer
verditers1344993verditers
vergers114412633verger_s
verges104320173ver__ges
verifies141313483verifies
verites103822263ver_ites
verities111418043verities
verjuices2142563verjuices
vermes115019143ver__mes
vermuths1642603vermuths
verniers11227843verniers
vernixes1836053vernixes
verrucas1343923verrucas
versers103813523verser_s
verses94223763ver__ses
versines112213823versines
verstes104014283ver_stes
versus94211143versu__s
vertexes18105623vertexes
vertices13612283vertices
vertus94613603vertu__s
verves124617883ver__ves
vesture10310373vesture_
vestured1237463vestured
virgules1244333virgules
virtues10338023virtu_es
viruses1039413vir_uses
vultures1137213vultures
xeruses143010753xer_uses

Search took 9 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.1701051123.5
2DLD Change Limit1461621667.94018408.3
3Display Results1661660.0602766.7
 (SQL Overall)1786911668.17021871.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.