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

238 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
framing133014791framing
famine114318192f_amine
faming124922972f_aming
famish14311842f_amish
farming133515082farming
flaming134216442flaming
foaming133612992foaming
foramina1346162foramina
framings14338132framings
fraying143413432fraying
amin66042253__amin_
amine75835383__amine
amino75425503__amino
amins75534323__amins
aramid93315613arami_d
aramids102810513aramids
arming94719803ar_ming
beaming123618803beaming
beamish14259293beamish
blaming123515693blaming
bracing123817613bracing
brain76229383bra_in_
brains85125473bra_ins
brainy114815643bra_iny
braking143917713braking
braving133714613braving
braying134416313braying
brazing193715113brazing
breaming133612513breaming
bromin102615693bromin_
bromine112915243bromine
bromins112513783bromins
carmine112918483carmine
coaming123818323coaming
cramming15339433cramming
cramping153411853cramping
craning103620303craning
craping124018713craping
crating103725203crating
craving134015733craving
crazing193914583crazing
creaming133413143creaming
cremini11229063cremini
crimine112413473crimine
crimini11258883crimini
criminy14268453criminy
diamin9312523diamin_
diamine10311983diamine
diamins10312213diamins
drain65222893dra_in_
drains73719403dra_ins
dramming14347563dramming
draping114213353draping
drawing123812053drawing
draying123813843draying
dreaming124011063dreaming
enamine91214313enamine
enframing1546113enframing
erasing8317963erasing
ermine8416923er_mine
etamin81311853etamin_
etamine91313073etamine
etamins91511833etamins
examine161510033examine
facing125321573f_acing
fading114821113f_ading
fagin9216573f_agin_
fagins10513863f_agins
fain75840563f_a_in_
faint85837063f_a_int
faith115620853f_a_ith
faking145520983f_aking
family143311703f_amily
famines123216263f_amines
farcing133514003farcing
farding123716743farding
farina94618233f_arina
faring105231283f_aring
farinha13357063f_arinha
farmings14298223farmings
farting114120753farting
fating105328673f_ating
faxing175117053f_axing
faying134521073f_aying
fazing194418643f_azing
fearing113520033fearing
feasing113916653feasing
feazing205411443feazing
filming133210353filming
firming132811223firming
flaking154114493flaking
flamen115215993flamen_
flamens124611063flamens
flamier123112143flamier
flamines13311643flamines
flamingo14274143flamingo
flamming16357153flamming
flaring114116803flaring
flavin1239303flavin_
flavine1338453flavine
flavins1338543flavins
flawing143812563flawing
flaying143914463flaying
flemish1536373flemish
fluming133512793fluming
foaling113515843foaling
foamier12339003foamier
foamily1546543foamily
foraging1358063foraging
foramen12310533foramen_
foramens1337823foramens
foraminal1444263foraminal
foraying1537433foraying
forming133615733forming
fraena938063fra_ena
fragging14329423fragging
fragile1147843fragile
fragment1448373fragment
frail85220213fra_i_l
frails93716473fra_ils
fraise94214913fra_ise
frame105821803fram__e
framed125116523fram_ed
framer114817443fram_er
framers125113823framers
frames115119863fram_es
franc104615413fra__nc
frank124417513fra__nk
franking164310863franking
frapping16348103frapping
frayings15325993frayings
frazil1847223frazi_l
frazils1956123frazils
freaking163611453freaking
freakish1845543freakish
freeing113713913freeing
frith115922033fr__ith
frizing203310873frizing
frumpish1843503frumpish
frying134511403fr_ying
fulmine1257963fulmine
fuming124013293f_uming
gamin84423003_gamin_
gamine94620153_gamine
gaming104622043_gaming
gamins94420043_gamins
gracing113216443gracing
gradin83517483gradin_
gradine93317033gradine
grading103918713grading
gradins93416233gradins
grain65126253gra_in_
grains74223093gra_ins
grainy103914213gra_iny
gratin74520583gratin_
gratine84719193gratine
grating93923183grating
gratins84119183gratins
graving123114563graving
graying124115883graying
grayish1437813grayish
grazing183514553grazing
griming113612493griming
harmin113117393harmin_
harmine122816193harmine
harming133717933harming
harmins123716723harmins
lamina84920443_lamina
laming94528363_laming
loaming103613733loaming
naming93917893_naming
orating83520323orating
praline93019743praline
prating103424453prating
praying133717323praying
primine113214823primine
priming123417373priming
promine112819443promine
racing95030533_racing
radish103516913_radish
raging85126433_raging
rain46251733_ra_in_
rains55140233_ra_ins
rainy85921083_ra_iny
raking114728423_raking
rakish134313963_rakish
ramen75625193_ramen_
rami66034093_rami__
ramie75027823_rami_e
ramies84630463_ramies
ramify14268753_ramify
ramming123115063_ramming
rammish1437563_rammish
ramona8412413_ramona
ramping123316873_ramping
rapine85023083_rapine
raping94829853_raping
rapini84714683_rapini
raring74332873_raring
rasing74330833_rasing
ratine65131823_ratine
rating74938703_rating
ravin85624653_ravin_
ravine95522223_ravine
raving105128853_raving
ravins94622563_ravins
ravish123414033_ravish
rawin85521473_rawin_
rawins95617623_rawins
rawish123012913_rawish
raxing144321023_raxing
raying105027193_raying
razing164524543_razing
reaming103924013reaming
reframing1538623reframing
remind94819793_remind
remint85329973_remint
riming93322223_riming
roaming103215793roaming
rumina83412483_rumina
seaming103222113seaming
shaming133016743shaming
stamina9310793stamina
taming94023433_taming
teaming103917593teaming
tracing103720153tracing
trading93517973trading
train56529113tra_in_
trains64725343tra_ins
tramline10311383tramline
tramming13279343tramming
tramping132711273tramping
trampish1535653trampish
tyramine1347303tyramine
varmint12311683varmint
warming133515083warming
warmish1538373warmish
wraith1258603wra_ith

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272387.11018850.5
3Display Results2382380.0932559.1
 (SQL Overall)1786912387.34324334.9
 
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.