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 “also” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
also4642344(None) 
als36663021als_
alto47831261alto
aals49941142aals_
aas310975392aas_
abo59045962a_bo
abos67734412abos
abs59356072abs_
ado49146882a_do
ados57633512ados
ads49755742ads_
aero45435342aero
agio57828452agio
ago48845522a_go
ags47551662ags_
ahs68644822ahs_
ails45654722ails_
ais39083582ais_
al210674042al__
ala312463602al_a
alae45643752alae
alamo7418142alamo
alan46844082alan
alar46340072alar
alas46358122alas
alb57342652al_b
alba68328332alba
albs68628572albs
aldol61212332aldol
ale36572342al_e
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alfa77624272alfa
alga57927602alga
algor6513052algor
alif76242142alif
alist56136782alist
alit46155692alit
alky115920342alky
all36148232al_l
allod64418382allod
allot54933872allot
allow85420662allow
alloy85519972alloy
alls46740922alls
ally76935642ally
alma66333032alma
alme65832162alme
alms65834922alms
aloe45540192aloe
aloof83521572aloof
alow75328592alow
alp56641132al_p
alps65529242alps
alt36467962al_t
altho86312602altho
altos55822952altos
alts46639902alts
alum65227612alum
ambo88225142ambo
ammo85520132ammo
ansa45927772ansa
apo511142122a_po
apos65433822apos
apse67725382apse
arco68331542arco
ars37670932ars_
arse46539272arse
arson55118832arson
arvo76023432arvo
as211083072a_s_
ash67944602a_sh
ask77130702a_sk
asp57235342a_sp
ass37844062a_ss
auto47432082auto
aviso85713962aviso
avo68936232a_vo
avos77227012avos
awls75926092awls_
ays67050292ays_
azo128233392a_zo
bals66354042bals_
balsa77920412balsa
basso76017282basso
calo64936442cal_o
calos74431902calos
canso75019402canso
dals57145122dals_
els37645722els_
else45923082else
false84818122false
fatso85113492fatso
gals57946502gals_
hallo85127552hallo
halo76437322hal_o
halos85230252halos
las37281472las_
lase46148512lase
lash76539652lash
lass47444542lass
lasso55015682lasso
last46260322last
lo28053442_l_o
loo38359822_loo
miso67229912miso
oleo46630482oleo
olio46829672olio
pals66951352pals_
palsy105417462palsy
peso66925822peso
piso66727572piso
sals46851672sals_
salsa56718922salsa
salvo84415642salvo
so28855442__so
valse85117522valse

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721190.87634100.5
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.186150666.9
 
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.