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

156 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
veneered123598(None) 
veneerer1145031veneerer
centered112513522centered
entered82718882_entered
fendered13258672fendered
gendered11258872gendered
rendered102512262rendered
sneered83113972_sneered
tendered102510602tendered
tentered96412102tentered
veered103612742v__eered
veneer94511692veneer__
veneerers1244522veneerers
veneers103710292veneer_s
ventured1238272ventured
aneared8512743_aneared
angered93013473_angered
bannered11299323bannered
bantered113313633bantered
beavered1437503beavered
beseemed1334863beseemed
bettered113011843bettered
bunkered15177183bunkered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
careered1139493careered
censored11197953censored
censured11248913censured
centred103411683cen_tred
cheered133713293_cheered
cindered1239793cindered
dandered112110963dandered
dangered11248513dangered
deferred13106363deferred
deterred10137803deterred
donnered10307753donnered
encored10412103_encored
endeared1038053_endeared
endured93611213_endured
enfevered1642963_enfevered
enserfed1245193_enserfed
ensured83512943_ensured
enterer72015633_enterer
enured73315333_en_ured
festered122512113festered
fettered12259493fettered
fevered14339723fe_vered
fingered13128333fingered
fleered11309503_fleered
gandered112211173gandered
gettered10258613gettered
gingered11127743gingered
hankered16289443hankered
hindered1339453hindered
hungered13217053hungered
hunkered16186923hunkered
inhered11313163_inhered
jeered143912793__jeered
kenneled1334003kenneled
kneeled12328073_kneeled
laveered1235253laveered
lavendered1541943lavendered
lechered1437523lechered
leered73816223__leered
lettered92910783lettered
levered114212303le_vered
linebred1144963linebred
lingered10129643lingered
mannered11249653mannered
meandered1346143meandered
membered1535903membered
mentored1138003mentored
meseemed1343963meseemed
metered103514013me_tered
mongered1238953mongered
neared75119803__neared
needed84114443__needed
neutered937423neutered
pandered121812573pandered
peered93819493__peered
peltered112510453peltered
peppered1236133peppered
pestered112814973pestered
petered103314973pe_tered
pioneered1253733pioneered
pondered126411293pondered
queered17117213_queered
redeemed1235593redeemed
reentered1038573reentered
refereed12149693refereed
referred1297833referred
regeared1039433regeared
reheeled1236773reheeled
renderer9239743renderer
reneged92010763ren_eged
renested92212953renested
renewed11309993ren_ewed
reseeded1038093reseeded
revered112819333re_vered
severed113513863se_vered
sewered112911243se_wered
sheered113515453_sheered
sintered92213903sintered
sneerer73512313_sneerer
sneezed17287793_sneezed
speered103614813_speered
steered83615253_steered
sundered10312153sundered
teddered11255183teddered
teetered9258303teetered
telfered1234883telfered
tempered13248223tempered
tenderer9228733tenderer
tenured838363ten_ured
tethered1238493tethered
tinkered1387683tinkered
unentered1037573unentered
unneeded1036483unneeded
vectored1435623vectored
velured1136683ve_lured
velveret1447043velveret
velveted1533833velveted
vended114416353ven__ded
vendee105617263vende_e_
vendees114011453vende_es
vender103418423vender__
venders113717003vender_s
veneering1337663veneering
venenated1345903venenated
venene92912523ven_ene_
venenes102712133ven_enes
venerated1339953venerated
venereal1145083venereal
veneries112815033veneries
venery123710663ven_er_y
venged114011993ven__ged
venire93513693ven_ire_
venires103012453ven_ires
venomed1336653ven_omed
vented104617923ven__ted
venter94218723venter__
venters103717733venter_s
venture10311173venture_
venturer1137243venturer
ventures11311493ventures
verderer1245373verderer
verdured13255763verdured
vesseled1243833vesseled
vestured1237463vestured
vinegared1442963vinegared
wandered132110793wandered
weltered12238433weltered
westered122511873westered
wintered122111573wintered
wondered13239943wondered

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.420425454.8
2DLD Change Limit1461621567.09320606.5
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.57623586.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.