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

189 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
flounder123510(None) 
flounders1374611flounders
founder114312571f_ounder
blonder104011942blo_nder
blunder103813142bl_under
bounder104215532_bounder
flaunter1135012flaunter
flinder11319872fl_inder
flooder11258462flo_oder
flounce1235412flounce_
flounced1433802flounced
flounces1335102flounces
flouncier1442482flouncier
floundered1542422floundered
flouter104311342flou_ter
flunker14389362fl_unker
fonder104120062f_o_nder
founded124011422f_ounded
founders123911672f_ounders
funder104016082f__under
grounder1047612grounder
hounder113412232_hounder
launder8309142_launder
louder74414602_lou_der
lounger84610212_lounger
plunder103810492pl_under
pounder103313992_pounder
rounder83514602_rounder
sounder83315382_sounder
abounded1234903abounded
aliunde835003aliunde_
asunder856223_asunder
blander103715163bl_ander
blender104613843bl_ender
blinder103912983bl_inder
blonde94813293blo_nde_
blondes104213163blo_ndes
blousier1055663blousier
blunders113911333bl_unders
blunger104112013bl_unger
blunter94512033bl_unter
bonder95324783_bo_nder
boulder103411343_boulder
bouncer113811333_bouncer
bounded113613763_bounded
bounden10389453_bounden
bounders114314113_bounders
cloner84418093clo_n_er
clouded11348833clou_ded
cloudier1135053cloudier
clouter93511693clou_ter
clowder13367933clo_wder
clunker13419453cl_unker
cofounder1543823cofounder
colander1139033colander
counter94220153_counter
daunder9348893_daunder
eloiner7149183eloin_er
eluder73712213el_u_der
expounder1943273expounder
fender103718723f__ender
finder104020233f__inder
flanger113412623fl_anger
flanker143911293fl_anker
flaunted1234603flaunted
flaunters1234513flaunters
flauntier1243063flauntier
flenser1036783fl_enser
flinders12439263fl_inders
flinger113710513fl_inger
floater104413353flo_ater
floatier1136983floatier
flockier1745343flockier
flogger12449463flo_gger
flooded12307933flo_oded
flooders12257833flo_oders
floorer10248073flo_orer
flopover1642863flopover
flopper14328473flo_pper
floppier1554633floppier
flosser10339693flo_sser
flossier11326973flossier
flouncy1543673floun_cy
floundering1642483floundering
flour84916453flou___r
floured11289873flou_red
flouted113210813flou_ted
flouters11419273flou_ters
flower124815503flo__wer
flowerer1435453flowerer
flubber14287713fl_ubber
fluffer12336503fl_uffer
flukier14397853fl_ukier
flunked15398413fl_unked
flunkers15347533fl_unkers
flunkey17405793fl_unkey
flusher133012273fl_usher
fluster103913063fl_uster
fluter95316863fl_u_ter
flutier103011553fl_utier
flutter104012093fl_utter
fodder114712113f_o_dder
folder104317543f_o_lder
fonded115717043f_o_nded
fondler11348883f_o_ndler
fouler93614903f_ou_ler
found94917843f_ound__
foundered1435403f_oundered
foundry1433913f_oundry
founds104814193f_ound_s
fronded12388863fro_nded
frondeur1242793fro_ndeur
fronter103611583fro_nter
frounce1236153frounce_
frounced1434493frounced
frounces1336183frounces
frouzier2043703frouzier
frowner13429683frown_er
funded114413893f__unded
funders113813933f__unders
funker133915763f__unker
funner93414103f__unner
grounded1136573grounded
grounders1156783grounders
hounded123311033_hounded
hounders123111713_hounders
impounder1443713impounder
joinder15337593_joinder
lander74028483_l_ander
lauder73815013_lau_der
launders9358743_launders
lender73921273_l_ender
loader74316313_lo_ader
loaner64416503_loan_er
loner55431043_lo_n_er
longer75823203_lo_nger
loonier73312683_loonier
louden73711793_lou_den
lounge75211213_lounge_
lounged9468243_lounged
loungers9449003_loungers
lounges84811353_lounges
lousier72411623_lousier
louver94110393_lou_ver
lunger75720423_l_unger
lunier64617603_l_unier
lunker104718343_l_unker
maunder10328683_maunder
moulder10389803_moulder
mounded113711983_mounded
mounter93713173_mounter
oleander936403oleander
plodder1146003plo_dder
plougher14214463plougher
plunders11329823pl_unders
plunger104211233pl_unger
plunker133910643pl_unker
ponder94521693_po_nder
pouncer113511233_pouncer
pounded114112793_pounded
pounders113113273_pounders
prouder10310383prou_der
rebounder1245103rebounder
refunder1236503refunder
relaunder1053703relaunder
rounded93013503_rounded
roundel8308853_roundel
rounders92613693_rounders
shoulder1234753shoulder
slander84015443sl_ander
slender83413593sl_ender
sloucher13206813sloucher
smoulder1133443smoulder
solander948123solander
sonder73623523_so_nder
sounded93214463_sounded
sounders93214113_sounders
stounded10276213stounded
sunder74019823__sunder
swounded13314563swounded
thunder1136963_thunder
trouncer1035443trouncer
under64624213___under
unsounder1044373unsounder
wonder103617813_wo_nder
wounded12329763_wounded
yonder103214133_yo_nder
younger11387163_younger
younker14316453_younker

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 Limit1461621896.76621602.4
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.98525582.1
 
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.