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

143 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
frounced143449(None) 
flounced1433801flounced
frounce1236151frounce_
frounces1336181frounces
trounced1135031trounced
bounced123610552_bounced
enounced1135882enounced
flounce1235412flounce_
flounces1335102flounces
founded124011422f_ounded
fronded12388862fro_nded
fronted114011272fro_nted
frowned14348832frown_ed
grounded1136572grounded
jounced17337612_jounced
pounced123510622_pounced
rounded93013502_rounded
trounce936822trounce_
trouncer1035442trouncer
trounces1037062trounces
abounded1234903abounded
amounted1135533amounted
announced1243293announced
arointed939003arointed
around72712413aroun__d
aroused84914343arou_sed
aroynted1244523aroynted
bedunced1453903bedunced
bounce104014833_bounce_
bouncer113811333_bouncer
bounces113813683_bounces
bounded113613763_bounded
bronzed19308213bro_nzed
browned134710973brown_ed
brunched16317853br_unched
counted103815803_counted
craunched1764023craunched
crooned103813343croon_ed
crouched16359143crouched
crowned133912433crown_ed
crunched16328163cr_unched
denounced1344033denounced
droned84616863dro_n_ed
drouked1335543drou_ked
drownded14334433drownded
drowned12419903drown_ed
enounce937573enounce_
enounces1037603enounces
fenced124412713f__enced
financed1435113financed
flaunted1234603flaunted
flocced15365483flo_cced
flouncier1442483flouncier
flouncy1543673flounc_y
flounder1235103flounder
floured11289873flou_red
flouted113210813flou_ted
flunked15398413f_lunked
foined105915013f_oin_ed
fonded115717043f_o_nded
forced126316523f_o_rced
fortuned1285323fortun_ed
fouled104315973f_ou_led
found94917843f_oun__d
founder114312573f_ounder
franked153610053fr_anked
frenched17299433fr_enched
friended1335033friended
fringed123611523fr_inged
frocked17439333fro_cked
frogeyed1642783frogeyed
frogged13408493fro_gged
frolicked1942613frolicked
frond95316343fro_n__d
fronter103611583fro_nter
frontes104214163fro_ntes
frosted113211873fro_sted
frothed14288783fro_thed
frouncing1534763frouncing
frouzier2043703frouzier
frowner13429683frown_er
frowsted1534313frowsted
frugged13387293fr_ugged
fruited11389093fr_uited
funded114413893f__unded
funked144214113f__unked
funned103613953f__unned
groaned9259973groan_ed
groined92710813groin_ed
grouched15356663grouched
ground82310273groun__d
grounder1047613grounder
grouped11419193grou_ped
groused94712833grou_sed
grouted94111503grou_ted
grunted9339283gr_unted
hounded123311033_hounded
ironed74916013iro_n_ed
jaunced17335473_jaunced
jounce153310733_jounce_
jounces16369853_jounces
lounged9468243_lounged
mounded113711983_mounded
mounted103611533_mounted
ounce77019933__ounce_
ounces83617773__ounces
ponced114314813_po_nced
pounce105214093_pounce_
pouncer113511233_pouncer
pounces114113893_pounces
pounded114112793_pounded
pranced123714043pr_anced
produced1456073produced
pronged113912393pro_nged
pronounced15243723pronounced
pruned93413113pr_un_ed
renounced1245923renounced
romanced1337253_romanced
rouged86717323_rou_ged
roughed124210943_roughed
round64318433_roun__d
roundel8308853_roundel
rounder83514603_rounder
rouped95717353_rou_ped
roused75426443_rou_sed
rousted84013323_rousted
routed75624333_rou_ted
sconced12359173sco_nced
scrounged1343143scrounged
sounded93214463_sounded
sourced1038453_sourced
stounded10276213stounded
swounded13314563swounded
swouned11366663swoun_ed
tranced104414173tr_anced
troubled1134983troubled
trouncers1134803trouncers
trouped103910983trou_ped
truced95312053tr_u_ced
trunked12358413tr_unked
unrounded1135863unrounded
wounded12329763_wounded
wronged12397673wro_nged

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.440406115.9
2DLD Change Limit1461621437.39019778.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.89322639.2
 
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.