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

196 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
palea7502866(None) 
galea64722941galea
pale66055011pale_
paleae84820291paleae
paleal84716671paleal
paled85538721paled
paler75436931paler
pales75753801pales
palet74650801palet
pilea75123951pilea
plea66830601p_lea
ala312463602_al_a
alae45643752_alae
alba68328332_alba
ale36572342_ale_
alec66430062_alec
alee46652322_alee
alef76340692_alef
ales47067102_ales
alfa77624272_alfa
alga57927602_alga
alma66333022_alma
apnea73413412apnea
area45843392_area
asea46327182_asea
azalea1537002azalea
bale66353842bale_
baled85436442baled
baler75635272baler
bales76250082bales
balsa77920412balsa
calesa8412472calesa
calla74827072calla
dale55643982dale_
dales66439742dales
flea75628492_flea
gala55635162gal_a
gale56347322gale_
galeae74717452galeae
galeas74618512galeas
galena74911092galena
gales65442482gales
hale76052832hale_
haled95335822haled
haler85033522haler
hales85449842hales
halma108219252halma
halva115414432halva
ilea45931462_ilea
kale86533752kale_
kales95730982kales
kalpa114512192kalpa
lea37660182__lea
male66052302male_
males75049792males
nala46930392nal_a
naled65525052naled
olea46532722_olea
paca85132242pa_ca
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
pacha126518062pacha
padle84522342padle_
padles95221122padles
paean77222722pa_ean
paella8410912paella
page76036102page_
paged95926782paged
pager84728202pager
pages85235072pages
paisa76021072paisa
pakeha1533932pakeha
pal56761672pal__
palapa10310672palapa
paleate94120002paleate
palely11311932palely
palest83926222palest
palets85122312palets
palier85023562palier
pall65039342pal_l
palled94625162palled
pallet84232652pallet
pallia83015592pallia
palls74332562palls
pally105727122pally
palm85331362pal_m
palmar104113462palmar
palmed114314642palmed
palmer105816542palmer
palms94921752palms
palmy126016732palmy
palp85828572pal_p
palpal104112052palpal
palped114513642palped
palpi95414552palpi
palps94719562palps
pals66951352pal_s
palsy105417462palsy
palter84423262palter
paly95835532pal_y
pampa114913422pampa
panda85022612panda
pane64950292pane_
paned85437182paned
panel76023622panel
panes76148692panes
panga85323532panga
papa85827142pa_pa
paper95128662paper
para65242172pa_ra
parae76335702parae
pare66760842pare_
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parka115120882parka
parle75836162parle_
parled94626292parled
parles86334402parles
parley116718362parley
pase65346862pase_
paseo77022512paseo
pases75346502pases
pasha105417182pasha
pasta76624532pasta
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pawed115725612pawed
pawer104422972pawer
paxes144928422paxes
payed115925932payed
payee105524722payee
payer105125722payer
pea56657242p__ea
pealed95322812pealed
pele65539552pele_
peles75738082peles
perea75026442perea
pile65649692pile_
piled85232992piled
pilei74021782pilei
piles74742612piles
playa105812942playa
plaza164311062plaza
plead85818462p_lead
pleas75627032p_leas
pleat74734472p_leat
pleb86123812p_leb
pled75231432p_led
plena75816392p_lena
plew97222812p_lew
plex137321372p_lex
pole65951302pole_
poleax1547992poleax
poled84934842poled
poler74431792poler
poles75351002poles
polka11310412polka
pula65129372pul_a
pule65040952pule_
puled84926522puled
puler74826622puler
pules74538812pules
rale45050562rale_
rales54947492rales
sale44959702sale_
salep77022952salep
sales56055592sales
salpa75018352salpa
salsa56718922salsa
spale74929212spale_
spales84728102spales
tala45938052tal_a
tale46154162tale_
taler56034862taler
tales55451372tales
vale74937342vale_
vales85434262vales
valet84337872valet
wale74546432wale_
waled94330992waled
waler84229262waler
wales86142832wales
walla85321032walla

Search took 3 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 Limit538001961.64032804.9
3Display Results1961960.0464260.9
 (SQL Overall)1786911961.99989390.2
 
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.