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 “marimba” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
marimba135498(None) 
marimbas1444361marimbas
caramba1336892caramba
kalimba1542662kalimba
macumba1573042macumba
mamba116317522ma__mba
maremma1044462maremma
maria75032882mari__a
marina84623412mari_na
maxima17568632maxim_a
zariba1736982zari_ba
ahimsa1134783_ahimsa
akimbo1443393_akimbo
amrita8411133amri_ta
anima74620073_anim_a
aria46245423_ari__a
arista6415293_arista
aroma71220143_arom_a
arriba867683_arriba
arroba898663_arroba
barilla9310323barilla
barista9310813barista
berimbau1472193berimbau
cabomba1544083cabomba
caribe103416753cari_be
carina84325333cari_na
carioca1139683carioca
farina94618233fari_na
farinha13357063farinha
gamba106018513ga__mba
hariana10310243hariana
harissa1035503harissa
jarina134014063jari_na
kalimbas1642323kalimbas
karma113415003kar_m_a
limba95414983__limba
macumbas1653013macumbas
mafia104418033mafi__a
magma104513573ma_gm_a
mailbag1243923ma_ilbag
maim85831493ma_im__
maimed114812663ma_imed
maimer104514593ma_imer
maims96321793ma_im_s
mama86231593ma__m_a
mambas125716243ma__mbas
mambo115215743ma__mbo
mamma86317913ma__mma
mania75634153mani__a
manila84518303mani_la
manilla93012473manilla
manioca11358943manioca
mara67444573mar___a
maraca10314153mar_aca
maranta9311693maranta
marasca1136823marasca
maremme1054603maremme
marimbist1543893marimbist
marinara1046493marinara
marinas93519393marinas
marine84230403mari_ne
mariner93315993mariner
marines93928013marines
mariposa1243703mariposa
marish114319053mari_sh
marital92314183marital
marka114620793mar__ka
markka11416593mar_kka
markkaa12373923markkaa
marmite112413993marmite
marmot10318743mar_mot
marsala939583marsala
mastaba1146223mastaba
matilda1044983matilda
maxilla16248193maxilla
maxim165216003maxim__
maximal18347093maximal
maximin1835263maximin
maxims17399673maxim_s
maximum1743573maximum
mazuma1935603mazum_a
mimbar1297493m__imbar
minima105512653minim_a
myrica1336833myri_ca
prima95019343_prim_a
rumba93612513__rumba
samba95618773sa__mba
tarama8412733taram_a
varia85824203vari__a
variola1068893variola
zareba1736423zar_eba
zareeba1842423zareeba
zaribas1836043zari_bas

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.436409841.7
2DLD Change Limit134027937.36018210.2
3Display Results93930.0303100.0
 (SQL Overall)178691937.82622833.0
 
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.