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

161 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
pakehas163531(None) 
pakeha1533931pakeha_
akelas10311192_akelas
pachas135017142pa_chas
pakoras1337472pakoras
pashas115117062pa_shas
aghas97014873_a_ghas
akees96119243_ake_es
akela9311343_akela_
akenes104817343_akenes
alohas9411703_alohas
alphas1139513_alphas
amebas10311453_amebas
apneas83211383apne_as
areas55935773_are_as
arecas84817443_arecas
arenas65021993_arenas
arepas85515703_arepas
bakers125323453bake_rs
bakes117035373bake__s
cakes116037673cake__s
calesas9411833calesas
cameras11313363cameras
canchas143212403canchas
catenas9313113catenas
dachas124113253da_chas
datchas1347423datchas
faenas94412763fa_enas
fakeers14446673fakeers
fakers134219533fake_rs
fakes126032483fake__s
fanegas1145713fanegas
favelas1337023favelas
galeas74618513gale_as
galenas83310343galenas
hahas117118443ha__has
hakeems16394803hakeems
hakes126034303hake__s
jakes165023643jake__s
kakas85117343kak__as
kashas133311903ka_shas
keas86337093__ke_as
lakers105225153lake_rs
lakes95737653lake__s
lakhs125210343lak_h_s
makefast1743293makefast
makers123921733make_rs
makes115336853make__s
makeups1533603makeups
malthas1237913malthas
nachas114914193na_chas
nakfas1334683nak_fas
okehs12477463_okeh_s
pacas96029403pa__cas
pacers105124543pace_rs
paces96741113pace__s
pacha126518063pa_cha_
packers153818893packe_rs
packets155114773packe_ts
padshah16113353padshah
padshahs17113153padshahs
paean77222723pa_e_an
paeans85118263pa_eans
paellas9411413paellas
paeons83915523pa_eons
paesan85114093pa_esan
paesans93312693pa_esans
pagers94423253page_rs
pages85235073page__s
pagodas11367553pagodas
paisas84317493pa_isas
pajamas18278153pajamas
pakora1247283pakora_
palapas11311493palapas
palea75028663pale_a_
paleae84820293pale_ae
paleal84716673pale_al
pales75753803pale__s
palets85122313pale_ts
paleways1645833paleways
pampas124913993pa_mpas
panadas103312213panadas
panamas113112763panamas
panchax2134983panchax
pandas95521963pa_ndas
panels84716523pane_ls
panes76148693pane__s
pangas99921103pa_ngas
panochas1545653panochas
papas94927493pa__pas
papayas1437273papayas
papers105125323pape_rs
paras76143043pa__ras
parches143720003parches
pardahs13289673pardahs
pareiras1038183pareiras
parents93418123parents
pareos87023773pare_os
parers85530743pare_rs
pares77164483pare__s
pareses94718883pareses
paresis93315093paresis
pareus85420743pare_us
pariahs123812343pariahs
parkas125018023pa_rkas
parkers133816873parke_rs
paruras9310533paruras
paschal14157243paschal
paschals1566473paschals
paseos88015813pase_os
pases75346503pase__s
pasha105417183pa_sha_
pashes115828393pa_shes
pastas85422873pa_stas
patacas11311003patacas
patches143320383patches
patellas1039103patellas
patens84820863pate_ns
patents94815203patents
paters84935833pate_rs
pates76047893pate__s
pathos115516693pa_thos
paths105521383pa_th_s
patinas96318523patinas
pavers115021823pave_rs
paves104833923pave__s
pawers114818783pawe_rs
paxes144928423paxe__s
payees114812903paye_es
payers114621823paye_rs
payolas12148973payolas
peas65755063p__e_as
pehs95625763p__eh_s
pekes114623563peke__s
pesetas938753pesetas
pesewas1236223pesewas
pietas84516503p_ietas
pikas114218093pik__as
pikeman1535523pikeman
pikers124717393pike_rs
pikes115031033pike__s
pleas75627033p_le_as
pokers124617923poke_rs
pokes116133013poke__s
pokeys15529513poke_ys
pukes114523023puke__s
rakees104516973rake_es
rakers104123573rake_rs
rakes94440353rake__s
sakers104125433sake_rs
sakes95540753sake__s
takahes1436173takahes
takas95520683tak__as
takers103923743take_rs
takes94437793take__s
takeups1333403takeups
vakeels14113733vakeels
wakens135012043wake_ns
wakers134822493wake_rs
wakes126633653wake__s
zarebas1836303zarebas

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 Filter1786911340270.500357382.0
2DLD Change Limit1340271617.11018850.5
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.67323288.3
 
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.