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

141 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
frounces133618(None) 
flounces1335101flounces
frounce1236151frounce_
frounced1434491frounced
trounces1037061trounces
bounces113813682_bounces
enounces1037602enounces
flounce1235412flounce_
flounced1433802flounced
frontes104214162fro_ntes
jounces16369852_jounces
ounces83617772__ounces
pounces114113892_pounces
trounce936822trounce_
trounced1135032trounced
trouncer1035442trouncer
trouncers1134802trouncers
announces1144483announces
arouses74921293arou_ses
bedunces1345513bedunces
bounce104014833_bounce_
bounced123610553_bounced
bouncer113811333_bouncer
bouncers12309353_bouncers
broncos11188073bro_ncos
broncs101611153bro_nc_s
bronzes183510403bro_nzes
brownies13189613brownies
brunches153710453br_unches
craunches1655723craunches
crones84729243cro_n_es
cronies9622503cro_nies
crouches153711293crouches
croupes114613103crou_pes
croutes94815653crou_tes
cruces105117543cr_u_ces
crunches153711353cr_unches
denounces1245413denounces
drones75023433dro_n_es
dunces95215753__dunces
enounce937573enounce_
enounced1135883enounced
faiences1337043faiences
fauces114916153f_au_ces
fences114617113f__ences
fiances12310673f_iances
finances1338653finances
florences1446893florences
flouncier1442483flouncier
flounciest1542563flounciest
flouncy1543673flounc_y
flounder1235103flounder
flounders1374613flounders
forces114422133f_o_rces
fornices1369103fornices
fortunes1158283fortun_es
founded124011423f_ounded
founder114312573f_ounder
founders123911673f_ounders
founds104814193f_oun_ds
founts94313383f_oun_ts
francs114112193fr_anc_s
frenches163311633fr_enches
frequences2444933frequences
fringes113514103fr_inges
frocks154111213fro__cks
froes86126693fro___es
frogeyes1543743frogeyes
frolics1236833frolic_s
fromages1437073fromages
fronded12388863fro_nded
fronds106412343fro_n_ds
frons86124043fro_n__s
fronted114011273fro_nted
fronter103611583fro_nter
fronts94415793fro_n_ts
frouncing1534763frouncing
frouzier2043703frouzier
frouziest2143973frouziest
frowned14348833frown_ed
frowner13429683frown_er
frowners14377933frowners
frowns126011393frown__s
furuncles1442493furuncles
grouches14328213grouches
grounded1136573grounded
grounder1047613grounder
grounders1156783grounders
grounds9228313groun_ds
groupies1137523groupies
grouses84616543grou_ses
groynes1137823groyn_es
grunges93310403gr_unges
irones64724013iro_n_es
ironies7517423iro_nies
jaunces16307423_jaunces
jounce153310733_jounce_
jounced17337613_jounced
launces9329003_launces
lounges84811353_lounges
nonces84418833_no_nces
ounce77019933__ounce_
ponces104720843_po_nces
pounce105214093_pounce_
pounced123510623_pounced
pouncer113511233_pouncer
pouncers12349203_pouncers
prances113618773pr_ances
princes113015143pr_inces
produces1347903produces
pronounces1454993pronounces
provinces1646853provinces
prunes83419063pr_un_es
rances84625443_r_ances
raunches1368053_raunches
renounces1147543renounces
romances12310793_romances
roubles93413513_roubles
rouches124217893_rouches
roues56039353_rou__es
rouges76022383_rou_ges
rounded93013503_rounded
roundel8308853_roundel
roundels9217753_roundels
rounder83514603_rounder
rounders92613693_rounders
roundest9310473_roundest
rounds73615623_roun_ds
rouses65436283_rou_ses
routes66129313_rou_tes
runes55530223_r_un_es
sconces113811453sco_nces
scrounges1243923scrounges
sources9312173_sources
trances93919643tr_ances
triunes74311383triun_es
trones65629283tro_n_es
troubles1057203troubles
troupes94112853trou_pes
truces84916333tr_u_ces
usaunces1073373usaunces

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.436409841.7
2DLD Change Limit1461621416.84621350.0
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.34524328.3
 
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.