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

386 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
martini9361387(None) 
martin84122521martin_
marting103325011marting
martinis103311611martinis
martins93322061martins
carting104228282carting
darting94020662darting
farting114120752farting
karting123716062karting
malting103219082malting
margin94016842margin_
margins103815192margins
marina84623412mar_ina
marine84230402mar_ine
marking144020132marking
marlin84220902marlin_
marline93320952marline
marling103322762marling
marlins93420472marlins
marring103319552marring
marten84518262marten_
martens93714952martens
martial92415412martial
martian93514682martian
martians103111612martians
martinet10319642martinet
masting104325822masting
matin75132852ma_tin_
mating94832912ma_ting
matins84527782ma_tins
mattin84416632mattin_
matting103620142matting
mattins93316142mattins
parting103527382parting
smarting113212452smarting
tarting84222652tarting
acini75718983_a_cini
actin74922553_actin_
acting95920983_acting
actinia91710853_actinia
actinic111810553_actinic
actins86321103_actins
airting83616303airting
amorini9310353amorini
anting75827023_anting
arcing95819643_arcing
arming94719803_arming
aroint6328153_aroint
arsine64021043_arsine
arsino64113513_arsino
artier63419733_artier
artily92814713_artily
artist64125543_artist
baiting103918883baiting
bambini1336583bambini
barbing123716993barbing
barding113822893barding
barfing134615093barfing
barging114018483barging
baring95135853bar_ing
barking144724183barking
barning104320353barning
barring104021593barring
bartend1038753bartend
basting104227203basting
bating95132253ba_ting
batting104422273batting
cantina93417253cantina
canting104725903canting
carbine112918643carbine
carding113922433carding
carina84325323car_ina
caring95137993car_ing
carking144322853carking
carlin84421823carlin_
carline93923613carline
carling103727063carling
carlins93921913carlins
carmine112918483carmine
carotin92216733carotin_
carotins102315583carotins
carping123521083carping
carton84522663carton_
cartons94122473cartons
carving133916773carving
casini84615863ca_sini
casting104628343casting
catting103922643catting
charting142614193charting
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
crating103725203crating
daring84928683dar_ing
darking134217343darking
darling93418363darling
darning93817333darning
dartling1039563dartling
dating85326483da_ting
dauting93814763dauting
dawting123610673dawting
earing75235483ear_ing
earning83418213earning
earring83519013earring
earthing12310323earthing
easting84924303easting
eating75134403ea_ting
farcing133514003farcing
farding123716743farding
farina94618233far_ina
faring105231283far_ing
farming133515083farming
farthing1538073farthing
fasting114522833fasting
fating105328673fa_ting
fatting113818703fatting
gaiting93716583gaiting
garbing113613273garbing
garni6315703gar__ni
garoting10510703garoting
garring93116713garring
gasting95022763gasting
gating84826953ga_ting
girting93113333girting
gratin74520583gratin_
gratine84719193gratine
grating93923183grating
gratins84119183gratins
hafting144014173hafting
halting114419073halting
hanting114124483hanting
haring104233003har_ing
harking154120943harking
harmin113117393harmin_
harmine122816193harmine
harming133717933harming
harmins123716723harmins
harpin113614383harpin_
harping134118383harping
harpins123615703harpins
hasting114725193hasting
hating104929713ha_ting
hatting113920233hatting
hearting12513123hearting
hurting113914033hurting
imparting1437243imparting
jarina134014063jar_ina
jarring153613193jarring
kartings13418523kartings
larding92917873larding
larine63927043lar_ine
larking123718253larking
lasting84725243lasting
latina65621143la_tina
latino64120473la_tino
latrine7715123latrine
lattin64316223lattin_
lattins74115483lattins
machine14313493machine
macing114221553ma_cing
madding123711993madding
maftir1136493mafti_r
maftirs1236043maftirs
mailing102923343mailing
maiming122912723maiming
main65345523ma__in_
mains75635113ma__ins
making134823853ma_king
malihini1344823malihini
maline84529083ma_line
malkin122913153malkin_
malkins133311803malkins
malling103623663malling
maltier93015483maltier
mankind1437773mankind
manning103616383manning
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantis83926033manti_s
mantling112012613mantling
mapping143413993mapping
marbling13179883marbling
marching164312193marching
margent10316693margent
marginal1137603marginal
margined1237743margined
margining1337603margining
maria75032883mar_i_a
marinas93519383mar_inas
mariner93315993mar_iner
marines93928013mar_ines
marish114319053mar_ish
marital92314183marital
maritime1247383maritime
marketing1636513marketing
markings153410243markings
marlier92614773marlier
marlines103818713marlines
marlings113713493marlings
marlite92917073marlite
marlitic1238343marlitic
marmite112413993marmite
maroon83118203maroon_
maroons92615553maroons
marrano939423marrano
married104715303married
marrier93817523marrier
marries93825283marries
marron83717543marron_
marrons93216973marrons
marrying14157223marrying
mart66865983mart___
marted94425213mart_ed
martinets1138883martinets
martingal1244063martingal
martlet93419153martlet
marts77442233mart__s
martyr1135693mart_yr
martyring1535783martyring
martyrs1234893martyrs
martyry1533373martyry
mashing134422243mashing
masking145116613masking
massing104318023massing
mastic103119173masti_c
mastics112614783mastics
mastiff1538163mastiff
mastitic1248263mastitic
mastitis1039103mastitis
mastix152310513masti_x
matier84321523ma_tier
matinal9312603ma_tinal
matinee92415613ma_tinee
matings104516213ma_tings
matrix1539843matri_x
matron83918313matron_
matrons93517633matrons
mattings11369673mattings
mauling103315683mauling
mavin105722953ma_vin_
mavins115119183ma_vins
mawing124020803ma_wing
maxing164817073ma_xing
maying124421153ma_ying
mayvin1436523mayvin_
mayvins1535323mayvins
mazing184418973ma_zing
meeting103314963meeting
melting103317753melting
merging112711763merging
merino8315093mer_ino
meriting11314683meriting
merlin83916683merlin_
merlins93015813merlins
mestino9411643mestino
meting94320593m_eting
metring103215293metring
milting103619123milting
mini65634563m___ini
minting103020813minting
mirin75023153mir_in_
miring93723803mir_ing
mirins83918903mir_ins
misting103623383misting
mitring103514143mitring
moating104218153moating
molting103517173molting
mooting103019363mooting
moraine9314573moraine
morainic12125673morainic
morning103215043morning
mortice11711493mortice
mortify1536223mortify
mortise9713533mortise
muntin82915183muntin_
munting103718773munting
muntins92715133muntins
murein8311763murein_
mureins9310733mureins
murine84220023mur_ine
muring95120373mur_ing
murrine9411483murrine
musting103221073musting
mutine84420373m_utine
muting93921523m_uting
mutiny113612683m_utiny
nardine82712573nardine
narine63422553nar_ine
narking124015383narking
nautili746113nautili
oaring74225303oar_ing
orating83520323orating
panini8314273pa_nini
panting104025423panting
pardine103616723pardine
parging113318603parging
paring94236493par_ing
parking143423043parking
parling103823763parling
parring103222063parring
parsing103819553parsing
partan83820563partan_
partans94418283partans
partial92616263partial
partied103516553partied
partier93520713partier
parties93230863parties
partings113513733partings
partita9310863partita
partite9317133partite
parton84720993parton_
partons94620513partons
partying14168893partying
pastina93914593pastina
pasting103826553pasting
patin76832853pa_tin_
patina86022193pa_tina
patine85328123pa_tine
patins87528783pa_tins
patting103722343patting
porcini1137633porcini
porting103021783porting
prating103424453prating
rafting113815753rafting
ranting84025413ranting
rapini84714683ra_pini
rappini11347573rappini
raring74332873rar_ing
ratine65131823ra_tine
rating74938703ra_ting
ratting83822363ratting
saltine75018563saltine
salting84120793salting
santimi938793santimi
sarcina9310733sarcina
sardine83317393sardine
sarin55239253sar_in_
sarins63932623sar_ins
satin55935223sa_tin_
sating74735453sa_ting
satins64930483sa_tins
satiny93817983sa_tiny
scarting113415263scarting
smaltine1037833smaltine
smarten9348863smarten_
smartens10286663smartens
smartie9310173smarti_e
smarties10312873smarties
sordini8228963sordini
sorting83221813sorting
spartina1037983spartina
starting93116173starting
tahini939893ta_hini
tankini11338923tankini
taring73932283tar_ing
tarring83318303tarring
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tartier74123263tartier
tartily103511573tartily
tartish101512633tartish
tasting84624213tasting
tatting84019523tatting
tauting83316383tauting
termini93410813termini
tortoni738033tortoni
varmint12311683varmint
varying1429723varying
vatting113614853vatting
wafting143911663wafting
waiting113618953waiting
wanting114220173wanting
warding123918143warding
waring105029443war_ing
warking153519573warking
warming133515083warming
warning113717093warning
warping133715183warping
warring113717973warring
wartier103413913wartier
wartime1237743wartime
wasting114422843wasting
yarding123413143yarding
yarning113512953yarning

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 Filter1786911340270.436409841.7
2DLD Change Limit1340273868.11016526.1
3Display Results3863860.1402757.1
 (SQL Overall)1786913868.68620572.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.