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

270 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
pakeha153393(None) 
pakehas1635311pakehas
akela9311342_akela
pacha126518062pa_cha
pakora1247282pakora
palea75028662pale_a
pasha105417182pa_sha
aceta74017353_aceta
agha87417303_a_gha
aha611246643_a__ha
akee85936813_ake_e
akees96119243_akees
akelas10311193_akelas
akene95818663_akene
aloha8513613_aloha
alpha1049653_alpha
ameba9312383_ameba
aphtha1444483aphtha
apnea73413413apne_a
area45843393_are_a
areca75618633_areca
arena55323813_arena
arepa75615563_arepa
asea46327183_ase_a
bake105637513bake__
baked126130773bake_d
baker115629543bake_r
bakers125323453bakers
bakery155911003bakery
bakes117035373bake_s
caeca93915133ca_eca
cake105439963cake__
caked126128623cake_d
cakes116037673cake_s
cakey145517273cake_y
calesa8412473calesa
camera10313673camera
cancha134411613cancha
catena8312473catena
dacha114812573da_cha
datcha1266563datcha
faena85014203fa_ena
fake115534943fake__
faked135225483fake_d
fakeer13378743fakeer
faker124824593fake_r
fakers134219533fakers
fakery16509263fakery
fakes126032483fake_s
fakey155515423fake_y
fanega1055783fanega
favela1237033favela
galea64722933gale_a
galena74911093galena
haha107821063ha__ha
hake115637843hake__
hakeem15407383hakeem
hakes126034303hake_s
jake155925773jake__
jakes165023643jake_s
kaka76518683kak__a
kasha124710723ka_sha
kea76540913__ke_a
lake85741603lake__
laked105731123lake_d
laker95432873lake_r
lakers105225153lakers
lakes95737653lake_s
lakh114919953lak_h_
lakhs125210343lak_hs
make105537883make__
maker114127813make_r
makers123921733makers
makes115336853make_s
makeup1434863makeup
makuta1236393makuta
maltha1137503maltha
naked105320853nake_d
nakfa1236093nak_fa
oaken95814383oake_n
okeh114615323_okeh_
okehs12477463_okehs
paca85132243pa__ca
pace86345773pace__
paced106931683pace_d
pacer96131613pace_r
pacers105124543pacers
paces96741113pace_s
pacey126720283pace_y
pachas135017143pa_chas
packed154822603packe_d
packer144223403packe_r
packers153818893packers
packet144726503packe_t
packets155114773packets
padshah16113353padshah
paean77222723pa_ean
paella8410913paella
paeon74819493pa_eon
paesan85114093pa_esan
page76036103page__
paged95926783page_d
pager84728203page_r
pagers94423253pagers
pages85235073page_s
pagoda10487873pagoda
pah88853593pa__h_
paiked135113433paike_d
paisa76021073pa_isa
pajama17317653pajama
pakoras1337473pakoras
palapa10310673palapa
pale66055013pale__
paleae84820293paleae
paleal84716673paleal
paled85538723pale_d
palely11311923palely
paler75436933pale_r
pales75753803pale_s
palest83926223palest
palet74650803pale_t
palets85122313palets
pallia83015593pallia
pampa114913423pa_mpa
panada94113053panada
panama104213343panama
panchax2134983panchax
panda85022613pa_nda
pane64950283pane__
paned85437183pane_d
panel76023623pane_l
panels84716523panels
panes76148693pane_s
panga85323533pa_nga
panocha1444983panocha
papa85827143pa__pa
papaya1337503papaya
paper95128663pape_r
papers105125323papers
papery134812743papery
papula103011113papula
para65242173pa__ra
parch125123003parch_
pardah123412823pardah
pare66760843pare__
pared86946763pare_d
pareira937533pareira
parent83230423parent
pareo74632603pare_o
pareos87023773pareos
parer75839903pare_r
parerga1035173parerga
parers85530743parers
pares77164483pare_s
pareu74928743pare_u
pareus85420743pareus
pareve114613013pareve
pariah114320583pariah
parka115120883pa_rka
parked134425133parke_d
parker124121373parke_r
parkers133816873parkers
parura8310583parura
paschal14157243paschal
pase65346863pase__
paseo77022513pase_o
paseos88015813paseos
pases75346503pase_s
pash95638133pa_sh_
pashas115117063pa_shas
pashed125923143pashed
pashes115828393pashes
pasta76624533pa_sta
pataca10311193pataca
patch125221223patch_
patchy16509573patchy
pate65350463pate__
pated85237843pate_d
patella938953patella
paten74827343pate_n
patens84820863patens
patent84524923patent
pater74740723pate_r
paters84935823paters
pates76047893pate_s
path99134913pa_th_
paths105521383pa_ths
patina86022193patina
pave96133893pave__
paved115525263pave_d
paveed12438893paveed
paver104225833pave_r
pavers115021823pavers
paves104833923pave_s
pawed115725613pawe_d
pawer104422973pawe_r
pawers114818783pawers
paxes144928423paxe_s
payed115925933paye_d
payee105524723paye_e
payees114812903payees
payer105125723paye_r
payers114621823payers
payola11208113payola
pea56657243p__e_a
peaked136117403peake_d
peh86740963p__eh_
pehs95625763p__ehs
peke105926203peke__
pekes114623563peke_s
perea75026443pere_a
pereia85217983pereia
peseta8310573peseta
pesewa1135543pesewa
pieta75421753p_ieta
pika106322953pik__a
pike106335213pike__
piked125623313pike_d
pikeman1535523pikeman
piker115622843pike_r
pikers124717393pikers
pikes115031033pike_s
pilea75123953pile_a
pineta85815563pineta
plea66830603p_le_a
plena75816393p_lena
poisha1135723poisha
poke105335363poke__
poked125425393poke_d
poker115122883poke_r
pokers124617923pokers
pokes116133013poke_s
pokey145318973poke_y
pokeys15529513pokeys
presa74319043p_resa
puke105025463puke__
puked124716223puke_d
pukes114523023puke_s
pukka10457133puk_ka
rake84841573rake__
raked105831423rake_d
rakee96031173rake_e
rakees104516973rakees
raker94529793rake_r
rakers104123573rakers
rakes94440353rake_s
sake85244963sake__
saker95132023sake_r
sakers104125433sakers
sakes95540753sake_s
spake114322743spake__
taka87623593tak__a
takahe1335793takahe
take84739263take__
taken94819143take_n
taker95229003take_r
takers103923743takers
takes94437793take_s
takeup1234583takeup
tapeta8310693tapeta
vakeel1335193vakeel
wake114935703wake__
waked135626753wake_d
waken124818473wake_n
wakens135012043wakens
waker125526593wake_r
wakers134822493wakers
wakes126633653wake_s
yakuza2261873yakuza
zareba1736423zareba

Search took 9 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.1401276364.3
2DLD Change Limit1127162708.00014089.5
3Display Results2702700.1561730.8
 (SQL Overall)1786912708.29621539.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.