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

190 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
appall1037974(None) 
appal95315221appa_l
appalls11337741appalls
appals104812941appals
appalled1344812appalled
apparel1146002apparel
appeal103911612appeal
appeals11378672appeals
appel94615892app_el
appels104312792appels
apple94517672app_le
apply125111392app_ly
pall65039342__pall
papal95820672papa_l
papally1437972papally
spall74919302_spall
aal39058673a__a_l
aals49941143a__als
agnail739533agnail
ahull84010313a_hull
algal66518223alga_l
alkali10127563alkali
all36148233___all
alpaca1047383alpaca
alphyl1484083alphyl
ample94720303amp_le
amply125012913amp_ly
ampul91110853amp_ul
ampule10710613ampule
ampulla1164303ampulla
ampuls1098893ampuls
anal48037523a_na_l
anally9513503a_nally
annal56520763anna_l
annals66415923annals
apace94718383a_pace
apart74330673a_part
apeak115513453apea_k
apetaly1237253apetaly
aphylly1843353aphylly
apian75018333apia_n
apiary113910383apiary
apical10913903apical
apically1539833apically
apicals1159923apicals
apneal83411123apneal
apodal9289833apodal
apollo837183apollo
app76827603app___
appalling1444923appalling
apparat11711713apparat
apparels1245123apparels
appealed1335603appealed
appealer1245743appealer
appear10379343appear
appears11308953appears
appease1137913appease
appellee1246253appellee
appellor1243573appellor
append1138273append
applaud1293903applaud
apples104315763apples
applet105917433applet
appose10411993appose
apps86319693app__s
appulse1134673appulse
aptly105111813a_ptly
areal55928733area_l
areally10411243areally
argal65023393arga_l
argala74712673argala
argali75013753argali
argals75517713argals
argyll1033643argyll
artal55525473arta_l
arval86017013arva_l
ashfall1343943ashfall
asphalt1248083asphalt
assail6610153assail
atlatl637873atlatl
atoll57913923a_toll
aural54428963aura_l
aurally10310543aurally
avail8313883a_vail
axal116520493a_xa_l
axial124515193axia_l
axially1737233axially
ball66043323__ball
befall114410643befall
begall92610723begall
call66838673__call
carpal103716253carpa_l
carpale113414353carpale
carpals113414633carpals
catcall1139153catcall
catfall1237393catfall
copal95621783copa_l
copalm125010813copalm
copals105018943copals
dapple1138853dapp_le
empale102611263empale
fall75535313__fall
gadwall1244563gadwall
gall56335993__gall
hall75741163__hall
happily1745763happily
impala10256933impala
impale102811663impale
infall939403infall
inwall938343inwall
kappa13469743kappa__
kappas144410363kappa_s
lall45531313__lall
mall64639373__mall
mappable1635923mappable
napalm1047263napalm
nappa98511863nappa__
nappas105511613nappa_s
nopal75517103nopa_l
nopals84914023nopals
opal66923523_opa_l
opals75718353_opals
pail66141833__pail
pal56761673__pa_l
pale66055013__pale
palls74332563__palls
pally105727123__pally
palm85331363__palm
palp85828573__palp
palpal104112053palpa_l
pals66951353__pals
paly95835533__paly
papa85827143papa__
papacy1547493papacy
papain10313793papain
papas94927493papa_s
papaw125112493papa_w
papaws13419113papaws
papaya1337503papaya
papilla11127913papilla
papula103011113papula
papule102212133papule
pawl95123263__pawl
peal68648103_pea_l
peals75235493_peals
pearl75324463_pearl
phalli1148263_phalli
pial65636703_pia_l
pill65339463__pill
pipal95118353pipa_l
pipals104213643pipals
poll66332133__poll
prill74117943_prill
psalm949273_psalm
pull64731663__pull
pupal97616873pupa_l
rappel104211953rapp_el
rappels11448803rappels
recall83815723recall
refall94314393refall
repoll8410793repoll
sall44544683__sall
sappily1437163sappily
scall74420373_scall
sepal77723003sepa_l
sepals85217373sepals
shall85024053_shall
small74016263_small
spail74921553_spail
spale74929213_spale
spalls84217343_spalls
spell75020303_spell
spill74821163_spill
sprawl11188063sprawl
squall1538003squall
stall54722353_stall
tall47240213__tall
tampala1136613tampala
tapalo839793tapalo
tappable1436343tappable
tepal76319583tepa_l
tepals85415043tepals
thrall93810293thrall
trapball1244753trapball
typal105311153typa_l
uphill11106173uphill
uppile10178503uppile
uptalk1234653uptalk
upwell11285803upwell
wall76236103__wall

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161905.93618988.5
3Display Results1901900.0633015.9
 (SQL Overall)1786911906.37528030.0
 
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.