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

104 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
falbala123587(None) 
falbalas1345471falbalas
albata839332_albata
cabala103516912ca_bala
cabbala1367182cabbala
fallal93612692fallal_
fallals103310192fallals
halala94715092hal_ala
kabala124011552ka_bala
kabbala1584612kabbala
qabala17399192qa_bala
tambala1138022tambala
abaca95118043_a_baca
abaka114313823_a_baka
abaya104413173_a_baya
alba68328333_alb__a
albas75925393_alba_s
albatas938373_albatas
alfalfa1342443_alfalfa
algal66518223_algal_
alkali10127563_alkali
alpaca1047383_alpaca
alula5317093_al_ula
argala74712673_argala
balata8614673bal_ata
balboa10389963balb_oa
barbal104016663barbal_
cabal95222153ca_bal_
cabalas113516003ca_balas
cabals104020153ca_bals
cabana103913563ca_bana
cabbalah1763793cabbalah
cabbalas1467373cabbalas
calabaza2143463calabaza
calla74827073cal__la
cantala94114673cantala
fable105824753fa_b_le
fabular12288693fa_bular
facial113615633facial_
facials123310743facials
facula112912233fa_cula
fadable13310463fadable
faecal11359813faecal_
fahlband1742643fahlband
falcate12311613falcate
fall75535313fal__l_
fallacy1536433fallacy
fallaway1743903fallaway
fallback1944553fallback
falls85727653fal__ls
falsely1336013falsely
farfal123410183farfal_
farfals13268503farfals
fastball1344913fastball
fatal84819373fa_tal_
fatback1836923fatback
faucal11339963faucal_
faucals12326563faucals
faunal94711593faunal_
favela1237033fa_vela
favella1336173favella
fella84918653fel__la
fibula11258053f_ibula
filial93013253filial_
flabella1344963flabella
galabia1038323galabia
halal85623593hal_al_
halalah13429393hal_alah
halalas104214083hal_alas
halals95018313hal_als
hallal94415563hallal_
hawala12368913ha_wala
kabaka11348503ka_baka
kabalas133911063ka_balas
kabaya15387123ka_baya
kabbalah1962433kabbalah
kabbalas1674353kabbalas
kamala12339963ka_mala
labara83712893la_bara
lambada1245643lambada
mandala10310213mandala
marsala939583marsala
masala8311813ma_sala
palabra1137183palabra
palapa10310673pal_apa
paleal84716673paleal_
palpal104112053palpal_
qabalah21285033qa_balah
qabalas18289503qa_balas
rambla103510933ramb_la
sabal75422483sa_bal_
sabals84618863sa_bals
salable91415463salable
salably121610743salably
salal55425703sal_al_
salals65120083sal_als
sambal105215183sambal_
sambals115213483sambals
tabla73318363ta_b_la
tambalas1237033tambalas
tampala1136613tampala
valval12398863valval_
valvula1343253valvula
walla85321033wal__la

Search took 7 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.406440125.6
2DLD Change Limit1340271045.81323056.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.26528522.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.