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

147 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
calla7482707(None) 
call66838671call_
callan83619601callan
callas84526751callas
calls75634731calls
cella75420311cella
challa114014191challa
walla85321031walla
ala312463602_a_la
alba68328332_alba
alfa77624272_alfa
alga57927602_alga
all36148232_all_
allay85620392_allay
alls46740922_alls
ally76935642_ally
alma66333022_alma
alula5317092_alula
ball66043322ball_
ballad94315322ballad
balls76236412balls
bally105530102bally
balsa77920412balsa
bulla74620562bulla
cabal95222152cabal
cabala103516912cabala
cable95329912cable
caca85528082ca_ca
caeca93915132caeca
calcar10312752calcar
calesa8412472calesa
calf96339562ca_lf
calfs104919382calfs
calif104929102calif
calix145317352calix
calk105527662ca_lk
calks115421602calks
callans94518472callans
callant94121222callant
called94126732called
callee84327292callee
caller85125482caller
callet84536762callet
callow114714662callow
callus85317072callus
calm85032362ca_lm
calmly1337612calmly
calms95222352calms
calo64936442ca_lo
calos74431902calos
calpac123211062calpac
calve105919922calve
calx135722792ca_lx
calyx17518192calyx
canal75428042canal
canella9310792canella
canna75919332canna
canola8313622canola
canula8312962canula
carl65144782carl_
carle74535702carle
carls77037422carls
casa65630862ca_sa
caul65630002caul_
cauld85318442cauld
caulk115315452caulk
cauls75727772cauls
cavalla1257882cavalla
cell65031722cell_
cellae84915932cellae
cellar84514982cellar
celli76717692celli
cello74919582cello
cells75428062cells
challah15458322challah
challas124414122challas
chally144314292chally
chela103916802chela
chola104718032chola
cholla113911022cholla
cilia73016762cilia
coala77521122coala
cola66541392c_ola
collar83816172collar
colly104926772colly
colza165112982colza
cull65929642cull_
cullay113910172cullay
culls75425812culls
cully105520462cully
culpa93610962culpa
dally95324742dally
fall75535312fall_
fallal93612692fallal
falls85727652falls
fella84918652fella
gala55635162ga_la
galea64722942galea
gall56335992gall_
galls64729322galls
gally95026172gally
halal85623592halal
halala94715092halala
hall75741162hall_
hallah124115402hallah
hallal94415562hallal
hallo85127552hallo
halloa94918122halloa
halls85633782halls
halma108219252halma
halva115414432halva
holla84918492holla
kalpa114512192kalpa
lall45531312lall_
lallan63414172lallan
lalls55324132lalls
mall64639372mall_
malls76233432malls
mulla74317112mulla
nala46930392na_la
olla44821172_olla
paella8410912paella
palea75028662palea
pall65039342pall_
pallia83015592pallia
palls74332562palls
pally105727122pally
rally84725902rally
salal55425702salal
sall44544682sall_
sally85129712sally
salpa75018352salpa
salsa56718922salsa
scall74420372scall_
scalls84218202scalls
scilla8310942scilla
tabla73318362tabla
tala45938052ta_la
tall47240212tall_
talls55133432talls
tally84526862tally
villa85321232villa
wall76236102wall_
wallah124011992wallah
wallas95719392wallas
walls85529382walls
wally114625092wally

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 Filter178691538000.313570897.8
2DLD Change Limit538001471.47036598.6
3Display Results1471470.0463195.7
 (SQL Overall)1786911471.82997698.7
 
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.