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

167 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
frenzies203771(None) 
frenzied2144041frenzied
freebies1337872freebies
freezes193310352freez_es
frenches163311632frenches
frenzily2343732frenzily
frizzies19315932frizzies
trendies9312212trendies
agencies1138743agencies
agenizes18269743agenizes
ardencies1247853ardencies
arenes64928393aren__es
arenites8917103arenites
bennies93917313_bennies
benzines1938213_benzines
benzins1838693_benzins
blennies1056933blennies
brandies11714563brandies
breezes18318693breez_es
breezier1934533breezier
breeziest2035063breeziest
brinies93317913brin_ies
bronzes183510403bronz_es
bronzier1935633bronzier
bronziest2035813bronziest
brulzies1933983brulzies
crannies10313013crannies
crazies183413853cr_azies
creepies1239613creepies
cronies9622503cron_ies
denies74729643_den_ies
drearies92313413drearies
drenches14309803drenches
envies9314053__envies
faeries104118993fae_ries
fancies124018783f_ancies
fannies103415643f_annies
fanzines2036913f_anzines
feazes184514173f_eaz_es
feezes184412613f_eez_es
fellies104119743f_ellies
fences114617113f_en_ces
fennier10339253f_ennier
fenniest113113203f_enniest
ferities111416713ferities
ferlies103216693f_erlies
ferneries1239043ferneries
fernier103110823fern_ier
ferniest1132214153fern_iest
ferries103521083f_erries
fervencies1845183fervencies
fezes175220023f_e_z_es
fezzes174910403f_e_zzes
fineries112416743fineries
fireflies1545353fireflies
flenches163410533flenches
flenses1039473flen_ses
floozies20326953floozies
fluencies1445933fluencies
flunkies1536393flunkies
forenames1447543forenames
forensics1443833forensics
francizes2346793francizes
frazils1956123fr_azils
frazzles19284813frazzles
freakier15246483freakier
freakiest16206693freakiest
freckles17126383freckles
freebees1345353freebees
freebie1236043freebie_
frees86131393fre___es
freesias1146333freesias
freeze18349513freez_e_
freezer19348523freez_er
freezers20307173freezers
freezing21308323freezing
frenched17299433frenched
frenetics1444603frenetics
frenums1236203fren_ums
frenziedly2651323frenziedly
frenzy2135883frenz__y
frenzying2542413frenzying
freres94716173fre__res
frescoes1357833frescoes
freshes133515823fre_shes
frettier1156593frettier
frettiest1267063frettiest
friaries11310083friaries
friendlies1442933friendlies
fries85535603fr___ies
friezes19418913friez_es
fringes113514103frin_ges
fringier1236553fringier
fringiest1347603fringiest
fritzes19329453fritz_es
frizes184015463fr_iz_es
frizzes18338183fr_izzes
frizzier19284813frizzier
frizziest20294143frizziest
frizzles19297283frizzles
fromenties1546673fromenties
frontes104214163fron_tes
frontier1147313frontier
frontiers1254993frontiers
frouzier2043703frouzier
frouziest2143973frouziest
frowzier2343313frowzier
frowziest2443483frowziest
frumenties1544433frumenties
funnies104113603f_unnies
furmenties1544853furmenties
genies75324943_gen_ies
grannies9312613grannies
grecizes2035683grecizes
greenies9312673greenies
gremmies1355993gremmies
grenades1038433grenades
henries102718283_henries
irenics937833iren_ics
ironies7517423iron_ies
ironizes17510373ironizes
jennies143511623_jennies
lezzies1536203_lezzies
pennies94218813_pennies
phrensies1445743phrensies
plenties10314693plenties
predries112714383predries
preemies12512193preemies
premies113823063pre_mies
prenames12311643prenames
prentices131111903prentices
preppies1149683preppies
pretties10615133pretties
prexies163415003pre_xies
prezes173614693pre_z_es
randies84225663_randies
readies83324713_readies
redries83721713_redries
reflies104418533_reflies
refries104419733_refries
reifies104218283_reifies
relies65036423_re_lies
renails74917263_renails
renames92418053_renames
reneges82513593_reneges
renigs74314593_ren_igs
renins64526453_ren_ins
rennins74013413_rennins
rentes65431193_ren_tes
rentier73618223_rentier
rentiers83311763_rentiers
replies94521043_replies
resizes164216843_resizes
reties65436193_re_ties
retries74129073_retries
tennies73017973_tennies
trannies8415013trannies
treaties8316983treaties
trenails869843trenails
trenches133512603trenches
trendier937913trendier
trendiest1038423trendiest
twenties1137503twenties
urgencies1256643urgencies
weenies102915093ween_ies
wienies102213683wien_ies
wrenches163210233wrenches

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.1731032896.0
2DLD Change Limit1461621678.11018022.4
3Display Results1671670.0762197.4
 (SQL Overall)1786911678.35921377.1
 
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.