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

232 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
feature103985(None) 
featured1237681featured
features11310331features
cofeature1444152cofeature
creature1038722creature
defeature1344332defeature
denature938062denature
denture8311892denture
facture12108922facture
feater95224052feater_
feather133613502feather
filature1145422filature
fixture1734962fixture
fracture13147122fracture
future939562f_uture
gesture839242gesture
lecture9149512lecture
mature8313462_mature
measure939032measure
nature6311262_nature
renature839322renature
stature74410682stature
texture1497082texture
venture10311172venture
vesture10310372vesture
aperture1046383aperture
arcature1086483arcature
armature10106963armature
azure14911483__azure
beater84729393beater_
beaters94925043beaters
bravure1254393bravure
capture1138913capture
ceinture1036313ceinture
censure92310603censure
centare93113703centare
centre84316643cent_re
century1237193century
cloture9238453cloture
cofeatured1642713cofeatured
cofeatures1544003cofeatures
couture9310623couture
creatures1138413creatures
crenature1145753crenature
cubature1244693cubature
culture939393culture
datura738023_datura
defeatures1444003defeatures
demure9311533de_mure
denatured1146023denatured
denatures1038123denatures
dentures9312453dentures
departure1243803departure
eagre64315323_ea_gre
eater54639843_eater_
eaters65535953_eaters
eatery95316353_eatery
endure74014143_endure
ensure63416003_ensure
entire61617703_entire
enure53520223_e_nure
erasure736943erasure
etude63612303_e_tude
factures13129023factures
failure1035753failure
fare76354463f_a__re
fate75444283f_at__e
father125116713f_ather
fatter94523213f_atter
fauve114712073f_a_uve
fear75337793fea__r_
feared106320433fea__red
fearer94820183fea__rer
fearers104815273fearers
fears84829393fea__rs
fease84824873fea__se
feaster10812983feaster_
feasters11511563feasters
feat76458223feat___
featest102715113featest
feathered16188893feathered
feathers143513243feathers
feathery17368073feathery
featlier1136453featlier
featly123711753feat_ly
feats86432753feat__s
featurette1352863featurette
featuring1337323featuring
feaze175216313fea__ze
femur1038683fe_mur_
femurs1136713fe_murs
fere76342233fe___re
ferrule1035863ferrule
fertile10311733fertile
ferule93413203fe_rule
fescue1137493fescu_e
fester94723513fester_
festered122512103festered
festers104121393festers
festive1339773festive
fete75734923fe_t__e
fetor81214533fe_tor_
fetors91014473fe_tors
fetter94120383fetter_
fettered12259493fettered
fetterer11207813fetterer
fetters103517903fetters
fettle93713123fe_ttle
fetus85816543fe_tu_s
fetuses10310243fe_tuses
fiacre1137623fia_cre
figure10258833f_igure
filatures1245853filatures
fissure1036783fissure
fixtures1835283fixtures
fixure16256543f_ixure
flare84823633fla__re
flatter103815963flatter
flatus94310783flatu_s
flatuses1137173flatuses
flatware1444883flatware
flexure1743413flexure
fortune1068303fortune
fractur12135563fractur_
fractured15125043fractured
fracturer14134623fracturer
fractures14147233fractures
fracturs13146313fracturs
fraktur14153033fraktur_
frakturs15163263frakturs
frater94520593frater_
fraters103517213fraters
futures10310263f_utures
geniture946453geniture
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
gravure1134953gravure
heater94828303heater_
heaters104225223heaters
heather133914853heather
heaume1137543hea_ume
hectare1238463hectare
hektare1435503hektare
immature1244433immature
league758743leagu_e
leaguer835793leaguer
leather103815783leather
lectured11127223lectured
lecturer10136023lecturer
lectures101310153lectures
leisure736693leisure
lettuce943323lettuce
ligature945133ligature
manure8313653_manure
matured10310033_matured
maturer938973_maturer
matures9314303_matures
meagre9349323mea_gre
measured1136463measured
measurer1035953measurer
measures1038913measures
meatier93214613meatier
meatus85112923meatu_s
meatuses1038203meatuses
metre74821303me_t_re
mixture1635413mixture
multure939183multure
natured838963_natured
natures7311963_natures
neater64424313neater_
nervature1263823nervature
nervure1034973nervure
nurture736643nurture
ossature843303ossature
overture111511683overture
parure8312523_parure
pasture9311463pasture
peatier94017233peatier
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
picture1158613picture
pleasure1045543pleasure
posture9313253posture
prelature1146263prelature
premature1347783premature
quatre153512353quat_re
rapture937383rapture
rasure6311423_rasure
reassure847343reassure
recapture1384713recapture
renatured1047283renatured
renatures939443renatures
restore75822973restore
retire64927013re_tire
retore67630763re_tore
retune69121953re_tune
return623222523re_turn
retuse66617223re_tuse
rupture966163rupture
satire63218003_satire
seater64534153seater_
seaters74028943seaters
seaware1049623seaware
secure8513533se_cure
seisure738193seisure
seizure1634683seizure
serrature945003serrature
statue66015323statu_e
statures83711113statures
statute7419323statute
suture6313203_suture
teatime9310083teatime
teaware1048143teaware
tenure6311613te_nure
textured1695483textured
textures1597523textures
theatre10358493theat_re
torture738593torture
treasure846753treasure
velure939773ve_lure
ventured1238273ventured
venturer1137243venturer
ventures11311493ventures
venturi1037203venturi
verdure11287773verdure
vestured1237463vestured
vestures11311043vestures
vulture1036763vulture
wafture1334853wafture
weather133513223weather

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.300595636.7
2DLD Change Limit1340272326.51620568.9
3Display Results2322320.0932494.6
 (SQL Overall)1786912326.90925863.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.