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

79 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
falbalas134547(None) 
falbala1235871falbala_
albatas938372_albatas
cabalas113516002ca_balas
cabbalas1467372cabbalas
fallals103310192fallal_s
halalas104214082hal_alas
kabalas133911062ka_balas
kabbalas1674352kabbalas
qabalas18289502qa_balas
tambalas1237032tambalas
abacas104414723_a_bacas
abakas123911743_a_bakas
abayas114011703_a_bayas
albas75925393_alb__as
albata839333_albata_
alfalfas1441953_alfalfas
alkalis11148783_alkalis
alpacas1137073_alpacas
argalas84011083_argalas
balas76937213___balas
balatas9311833bal_atas
balboas113710073balb_oas
cabala103516913ca_bala_
cabals104020153ca_bal_s
cabanas112413033ca_banas
cabbala1367183cabbala_
cabbalah1763793cabbalah
cabbalahs1862723cabbalahs
calabazas2243083calabazas
callas84526753cal__las
cantalas104013523cantalas
fables114921673fa_b_les
fabular12288693fa_bular
facials123310743facial_s
fahlbands1842633fahlbands
fallal93612693fal__lal
fallaway1743903fallaway
fallaways1843163fallaways
fallbacks2044353fallbacks
falls85727653fal__l_s
farfals13268503farfal_s
fastballs1444443fastballs
fatbacks1946003fatbacks
faucals12326563faucal_s
favelas1337023fa_velas
favellas1446163favellas
fellas95116963fel__las
fibulas12228563f_ibulas
galabias1137733galabias
halala94715093hal_ala_
halalah13429383hal_alah
halalahs14367443hal_alahs
halals95018313hal_al_s
hawalas13348353ha_walas
kabakas12367403ka_bakas
kabala124011553ka_bala_
kabayas16316803ka_bayas
kabbala1584613kabbala_
kabbalah1962433kabbalah
kabbalahs2051903kabbalahs
kamalas13339123ka_malas
lambadas1354873lambadas
mandalas1139433mandalas
marsalas1038253marsalas
masalas9312053ma_salas
palabras1267353palabras
palapas11311493pal_apas
qabala17399193qa_bala_
qabalah21285033qa_balah
qabalahs22253293qa_balahs
ramblas112710263ramb_las
sabals84618863sa_bal_s
salals65120083sal_al_s
sambals115213483sambal_s
tablas83716163ta_b_las
tambala1138023tambala_
tampalas1245473tampalas
wallas95719393wal__las

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162797.26320124.2
3Display Results79790.0164937.5
 (SQL Overall)178691797.43524033.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.