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

235 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
features1131033(None) 
feature1039851feature_
featured1237681featured
cofeatures1543982cofeatures
creatures1138402creatures
defeatures1444002defeatures
denatures1038122denatures
dentures9312452dentures
factures13129022factures
feathers143513242feathers
fetuses10310242fe_tuses
filatures1245842filatures
fixtures1835282fixtures
flatuses1137172flatuses
fractures14147232fractures
futures10310262f_utures
gestures9310012gestures
lectures101310152lectures
matures9314302_matures
measures1038912measures
meatuses1038202meatuses
natures7311962_natures
renatures939442renatures
statures83711112statures
textures1597522textures
ventures11311482ventures
vestures11311032vestures
apertures1146473apertures
arcatures1186833arcatures
armatures1166953armatures
aures55137093__a_ures
azures15510183__azures
beaters94925033beater_s
beauties10229523beauties
captures1239433captures
ceintures1136733ceintures
censures102211623censures
centares102913893centares
centres93817123cent_res
centuries11311333centuries
cestuses1038083cestuses
clotures10299023clotures
cofeature1444143cofeature_
cofeatured1642703cofeatured
coutures10311973coutures
creature1038723creature_
crenatures1245323crenatures
cubatures1344413cubatures
cultures10310143cultures
daturas838763_daturas
defeature1344333defeature_
denature938063denature_
denatured1146023denatured
denture8311893denture_
departures1343533departures
eagres74014573_ea_gres
eateries8324303_eateries
eaters65535943_eater_s
endures83314603_endures
ensures73315903_ensures
entires71517783_entires
enures63919713_e_nures
erasures837203erasures
etudes73811603_e_tudes
facture12108923facture_
failures1135163failures
fares85852873f_a__res
fates85139233f_at__es
fathers133916503f_athers
fatsoes10379423f_atsoes
fatties103018203f_atties
fatuous1037783f_atuous
fauces114916153f_a_uces
fauves125610423f_a_uves
favuses1336183f_avuses
fealties1139993fealties
feared106320433fea__red
fearer94820183fea__rer
fearers104815273fea__rers
fears84829393fea__r_s
feases95422923fea__ses
feasters11511563feaster_s
feater95224053feat__er
featest102715113feat__est
feather133613503feat_her
feathered16188893feathered
feathery17368073feathery
featlier1136453featlier
featliest1238363featliest
feats86432753feat___s
featureless1452193featureless
featurette1352863featurette
featurettes1452323featurettes
featuring1337323featuring
feazes184514173fea__zes
femurs1136713fe_mur_s
feres86038183fe___res
ferrules1136163ferrules
ferules103112723fe_rules
fescues1236783fescu_es
festered122512103festered
festers104121393fester_s
fetches153413893fe_tches
fetes85630143fe_t__es
fetors91014473fe_tor_s
fettered12259493fettered
fetterer11207813fetterer
fetterers12267043fetterers
fetters103517903fetter_s
fettles103912733fe_ttles
fetus85816543fe_tu__s
fiacres1237253fia_cres
figures11239103f_igures
filature1145423filature_
fissures1136573fissures
fixture1734963fixture_
fixures17596063f_ixures
flares94521703fla__res
flatters113814203flatters
flatus94310783flatu__s
flatwares1544763flatwares
flexures1843423flexures
foetuses1136083foetuses
fortunes1158283fortunes
fracture13147123fracture_
fractured15125043fractured
fracturer14134623fracturer
fracturers15123203fracturers
fracturs13146303fractur_s
frakturs15163253fraktur_s
fraters103517203frater_s
furfures1445663furfures
future939563f_uture_
genitures1046123genitures
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gesturers1044283gesturers
gravures1234903gravures
heaters104225213heater_s
heathers143914733heathers
heaumes1237423hea_umes
hectares1338853hectares
hektares1535813hektares
hiatuses1135773hiatuses
immatures1344313immatures
leaguers935063leaguers
leagues837943leagu_es
leathers114215083leathers
lecture9149513lecture_
lectured11127223lectured
lecturer10136023lecturer
lecturers11124233lecturers
leisures836683leisures
lemures938793le_mures
lettuces1043503lettuces
levatores12225733levatores
ligatures1044923ligatures
manures9313353_manures
matres84522233_mat_res
mature8313463_mature_
matured10310033_matured
maturer938973_maturer
maturers1037373_maturers
maturest1039693_maturest
measure939033measure_
measured1136463measured
measurer1035953measurer
measurers1144883measurers
meatus85112923meatu__s
metres85121563me_t_res
mixtures1735753mixtures
multures1039333multures
nature6311263_nature_
natured838963_natured
nervatures1363523nervatures
nervures1135123nervures
nurtures837443nurtures
ossatures943423ossatures
overtures121611443overtures
parures9512693_parures
pastures10311963pastures
perdures11289683perdures
perjures17268083perjures
perturbs1244363perturbs
pictures1249343pictures
pleasures1145573pleasures
postures10313763postures
prelatures1245723prelatures
prematures1447043prematures
quatres163411923quat_res
raptures1037573raptures
rasures7312013_rasures
reassures937223reassures
recaptures1474463recaptures
renature839323renature_
renatured1047283renatured
restores85222983restores
retires74726213re_tires
retunes76918403re_tunes
returns79712593re_turns
ruptures1056683ruptures
satires72617573_satires
seaters74028933seater_s
seawares1139333seawares
secures9613163se_cures
seisures838273seisures
seizures1744633seizures
serratures1044853serratures
statues74614903statu_es
stature74410673stature_
statuses8409533statuses
statutes8368893statutes
sutures7314223_sutures
teatimes1039443teatimes
teawares1148083teawares
tenures7412013te_nures
texture1497083texture_
textured1695483textured
theatres11298633theat_res
tortures838913tortures
treasures946623treasures
velures1039093ve_lures
venture10311173venture_
ventured1238273ventured
venturer1137243venturer
venturers1245523venturers
venturis1138193venturis
verdures12247743verdures
vesture10310373vesture_
vestured1237463vestured
viatores11257673viatores
vultures1137213vultures
waftures1434853waftures
weathers143412833weathers

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.1561145455.1
2DLD Change Limit1461622357.00020880.3
3Display Results2352350.0962447.9
 (SQL Overall)1786912357.25224640.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.