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

134 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
galabia103833(None) 
galabias1137731galabias
galabiya1442761galabiya
galabieh1444822galabieh
galabiyah1851642galabiyah
galabiyas1542512galabiyas
galanga936022galanga
galatea839972galatea
gambia115912252ga_mbia
gazania1746122gazania
labia75219012__labia
malaria9313702malaria
palabra1137192palabra
talaria7412522talaria
abasia8712953_abasia
acacia10311353_acacia
agalactia1253453agalactia
alanin6317273_alanin
alaska1036713_alaska
alba68328333_al_b_a
albata839333_albata
alexia132910463_alexia
alibi7514233_alibi_
alibis8311073_alibis
alodia71112453_alodia
aplasia92510803aplasia
arabic10312733_arabic
arabica1147283_arabica
ataxia13179593_ataxia
balata8614683bala_ta
balboa10389963bal_boa
bilabial1265683bilabial
calabaza2143463calabaza
calami10313423calami_
calcaria1249543calcaria
caldaria1148953caldaria
calvaria1347893calvaria
cambia124913153ca_mbia
carabid12311333carabid
carabin11313213carabin
casaba1079263casab_a
chalazia2245133chalazia
dahabiah1742863dahabiah
dahabiya1741513dahabiya
dalasi7610623dalasi_
dalasis8810533dalasis
falbala1235873falbala
filaria1039653filaria
gala55635163gal___a
galabiehs1542453galabiehs
galabiyahs1951163galabiyahs
galactic13106553galactic
galago838913gala_go
galagos938153galagos
galah95917643gala__h
galahs105512683gala_hs
galangal1043893galangal
galangas1046173galangas
galas65731643gala__s
galateas937153galateas
galax135314463gala__x
galaxes1538883galaxes
galaxies1637173galaxies
galaxy17476313gala_xy
galea64722943gal__ea
galena74911093gal_ena
galenic1038693galenic
gallein8299043gallein
galleria946483galleria
galleta8399653galleta
gallic9411643gal_lic
gallica1047463gallica
galvanic1444513galvanic
gamba106018513ga_mb_a
gambias125010733ga_mbias
gambir11509773ga_mbir
gambit114714213ga_mbit
gammadia1443923gammadia
ganglia946613ganglia
gazabo1834833gazab_o
gazabos1944453gazabos
gazanias1845733gazanias
gelable101710733gelable
gelada837623gela_da
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
gigabit1145403gigabit
glacial1038143g_lacial
glacis94012133g_lacis
glair65313553g_la_ir
gleba83910243g_leb_a
glia56423153g_l__ia
globin9309723g_lobin
gloria71910553g_loria
halacha15388023halacha
halakha17416593halakha
halakic1656663halakic
halala94715093hala_la
jalapic1844543jalapic
jalapin1645923jalapin
kalmia1238893kal_mia
labial84714343__labial
labra75415463__labra
lamia75324323__lamia
latakia1146093latakia
malacca1344963malacca
malanga1036663malanga
malarial10410613malarial
malarian10311563malarian
malarias10313773malarias
malvasia13164963malvasia
palabras1267353palabras
paladin101011773paladin
palais8420423pala_is
palapa10310673pala_pa
palatial10410623palatial
palladia1146633palladia
pallia83015593pal_lia
patagia1068783patagia
ratafia1045773ratafia
salable91415463salable
salably121610743salably
salami8313103salami_
salamis9313513salamis
salariat8416303salariat
salvia93310753sal_via
solaria7312493solaria
solatia7312253solatia
tilapia945553tilapia
valonia1048303valonia
velaria1038923velaria
wasabi1154643wasabi_
wasabis1255363wasabis

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.423422437.4
2DLD Change Limit1340271347.07618941.1
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.56223630.1
 
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.