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

91 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
marimbas144436(None) 
marimba1354981marimba_
kalimbas1642322kalimbas
macumbas1653012macumbas
mambas125716242ma__mbas
marimbist1543892marimbist
marinas93519402mari_nas
zaribas1836042zari_bas
ahimsas1234783_ahimsas
amritas939093amri_tas
animas84418723_anim_as
arias55438023_ari__as
aristas7413523_aristas
aromas81018613_arom_as
arrobas969213_arrobas
barillas10310203barillas
baristas1039723baristas
berimbau1472193berimbau
berimbaus1561283berimbaus
cabombas1643813cabombas
caramba1336893caramba_
caribes113715643cari_bes
carinas93622423cari_nas
cariocas1239663cariocas
caritas93316963cari_tas
farinas103215253fari_nas
farinhas14325373farinhas
gambas115817513ga__mbas
harianas1139173harianas
harissas1145983harissas
jarinas143712203jari_nas
kalimba1542663kalimba_
karmas123013753kar_m_as
limbas105313203__limbas
macumba1573043macumba_
mafias113913573mafi__as
magmas115512503ma_gm_as
mailbag1243923ma_ilbag
mailbags1343903ma_ilbags
maimers113813043ma_imers
maims96321793ma_im__s
mamas95930773ma__m_as
mamba116317523ma__mba_
mambos125414493ma__mbos
mammas94616403ma__mmas
manias84029033mani__as
manilas93915873mani_las
manillas102611163manillas
maniocas12298473maniocas
maracas11313773mar_acas
marantas10310033marantas
maras75443293mar___as
marascas1247383marascas
maremma1044463maremma_
maria75032883mari__a_
marimbists1652243marimbists
marina84623413mari_na_
marinaras1145573marinaras
mariners103113873mariners
marines93928033mari_nes
mariposa1243703mariposa
mariposas1343543mariposas
marishes13512553marishes
marital92314183mari_tal
markas124717003mar__kas
markkas12356083mar_kkas
marmites122212793marmites
marmots11311513mar_mots
marsalas1038253marsalas
mastabas1246803mastabas
matildas1145023matildas
maxillas17227703maxillas
maxima17568633maxim_a_
maximal18347093maxim_al
maximals19325223maximals
maximins1944533maximins
maxims17399673maxim__s
maximums1842813maximums
mazumas2034623mazum_as
mimbar1297493m__imbar
mimbars1397383m__imbars
myricas1436753myri_cas
primas104418103_prim_as
rumbas102512013__rumbas
sambas104219263sa__mbas
taramas9612703taram_as
varias95019903vari__as
variolas1168543variolas
zarebas1836303zar_ebas
zareebas1943103zareebas
zariba1736983zari_ba_

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 Filter1786911461620.436409841.7
2DLD Change Limit146162917.81318707.5
3Display Results91910.0303033.3
 (SQL Overall)178691918.27921583.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.