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

80 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
bacalao114661(None) 
bacalaos1245861bacalaos
bacula103112672bacula_
baal67033113ba_al__
baalim1038473ba_alim
baals76122703ba_al_s
bacca111012183bac_ca_
baccae12119703bac_cae
baccara1347143baccara_
baccaras1446913baccaras
baccarat1447933baccarat
bacillar1276533bacillar
bacilli1146393bacilli
backland1748103backland
backlash1945923backlash
backlit15911903backlit
backload1746833backload
backlog1635773backlog
backsaw1836203backsaw
backslap1844993backslap
baculum1345703baculum
balas76937213b__alas
balata8614673balata_
balatas9311833balatas
ballad94315323ba_llad
banal75925993banal__
banally1249223banally
banana83213413banana_
bananas93312223bananas
basal75722283basal__
basally1237963basally
basalt83519583basal_t
basalts9358963basalts
basilar937303basilar
bayamo1335603baya_mo
bazaar17306403baza_ar
becalm1239203becal_m
becalms1335743becalms
cabala103516913cabala_
cabalas113516003cabalas
cacao95420003__cacao
calo64936443__cal_o
carabao1139673carabao
catalo8314853catal_o
cicala10310053cicala_
cicalas1139303cicalas
facula112912233facula_
faculae123210353faculae
facular122810443facular
halala94715093halala_
halalah13429393halalah
halalas104214083halalas
hawala12368913hawala_
hawalas13348353hawalas
jacal14313703jacal__
jacales16310323jacales
jacals1539873jacal_s
jacamar1844323jacamar
jacana1537933jacana_
jacanas1638263jacanas
kabala124011553kabala_
kabalas133911063kabalas
kamala12339963kamala_
kamalas13339123kamalas
macaco1247853maca_co
macadam1446853macadam
macula103013673macula_
maculae113412863maculae
macular113011943macular
maculas113114023maculas
masala8311813masala_
masalas9312053masalas
qabala17399193qabala_
qabalah21285033qabalah
qabalas18289503qabalas
scalado10276473_scalado
scalar83612433_scalar
tamarao977593tamarao
tapalo839793tapal_o
zocalo1735803zocal_o

Search took 10 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.826216332.9
2DLD Change Limit134027808.59315597.2
3Display Results80800.0332424.2
 (SQL Overall)178691809.45218905.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.