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

277 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
pikake1111580(None) 
pikakes1245821pikakes
pickaxe2244622pickaxe
pika106322952pika__
pikas114218092pika_s
pike106335212pi__ke
pipage1199142pipage
pirate82322882pirate
alkane104313323alkane
awake125014783_awake
bake105637513__bake
berake124216083berake
betake124512703betake
biface1358103biface
bike106532603bi__ke
bikie113915883bik_ie
binate8419773binate
brake116025343_brake
cake105439963__cake
cicale10314503cicale
comake144413423comake
crake114823523_crake
dekare112811563dekare
dike95935763di__ke
dilate73220693dilate
drake104918303_drake
epilate9314283epilate
fake115534943__fake
finale94116763finale
fixate1638733fixate
flake125119973_flake
hake115637843__hake
hike116830393hi__ke
ikat87626643_ika_t
ikats95311153_ikats
image81411293_image
inane52820343_inane
intake10510863intake
irade65618153_irade
irate55627983_irate
jake155925773__jake
kae76744543__ka_e
kaka76518683__kaka
kaki76520913__kaki
kale86533753__kale
kame105728233__kame
kane85133973__kane
kike76524783__kike
kinase104210653kinase
kishke1254273kishke
lake85741603__lake
liane54720663li_ane
ligase7259913ligase
ligate72519253ligate
likable13219413likable
like86040843li__ke
linage7713403linage
linkage1295963linkage
lipase8239103lipase
make105537893__make
mikado1344513mikado
mike105535293mi__ke
milage93414123milage
minae75627723mina_e
minke115421763mi_nke
mirage92313653mirage
misate81222693misate
mismake15139373mismake
mistake131312623mistake
nidate7313783nidate
opiate8513463opi_ate
pace86345773p__ace
package16128013package
page76036103p__age
palace104516913palace
palate84226783palate
pale66055013p__ale
pancake1536673pancake
pane64950293p__ane
parade94720643parade
parae76335703para_e
parbake1538353parbake
pare66760843p__are
parkade1437583parkade
partake1339643partake
pase65346863p__ase
pate65350463p__ate
pavane114113443pavane
pave96133893p__ave
peace95026083p_eace
peage84723563p_eage
peak106535203p_eak_
peaked136117403p_eaked
peaks114825623p_eaks
peaky145718153p_eaky
pease75231113p_ease
pedate93117763pedate
pekan111613973peka_n
pekans121710553pekans
peke105926203p__eke
pekoe114612363pek_oe
pelage9515363pelage
peruke123210393peruke
pesade9311103pesade
phage115113673p_hage
phase104617213p_hase
phrase11109903phrase
pia56848033pi_a__
piaffe1494913piaffe
pial65636703pi_a_l
pian66136093pi_a_n
piano76118713pi_ano
pians75126963pi_ans
pias66542553pi_a_s
piazze1634683piazze
pibal95217323piba_l
pibals103813083pibals
pica85831493pica__
pical95524373pica_l
picante11310523picante
picara10311903picara
picaro10311323picaro
picas94626523pica_s
pice84641093pi__ce
pick125933813pi_ck_
pickax2135913picka_x
pickaxed2443513pickaxed
pickaxes2344913pickaxes
picked154421313pi_cked
picker144422173pi_cker
picket144924313pi_cket
pickle144215653pickle
picks135226143pi_cks
picky165416943pi_cky
picrate112014143picrate
piddle103514913piddle
pie55457403pi___e
piece96717993pi_ece
pierce104010393pierce
piffle14418233piffle
piggie103210773piggie
piglike14157313piglike
piked125623313pik_ed
pikemen1535333pikemen
piker115622843pik_er
pikers124717393pikers
pikes115031033pik_es
piki106520563pi__ki
piking133719643piking
pikis115116393pik_is
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pila_r
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
pile65649693pi__le
pileate93815923pileate
pillage103412603pillage
pilose84514243pilose
pilule8411123pilule
pima85428653pima__
pimas94725103pima_s
pimple123512963pimple
pina65842633pina__
pinang92611593pinang
pinas75434453pina_s
pinata83817223pinata
pine67755713pi__ne
pinene82915643pinene
pinite8321243pinite
pink107039383pi_nk_
pinked134819883pi_nked
pinken124513283pi_nken
pinker125322443pi_nker
pinkey154314673pi_nkey
pinkeye16326493pinkeye
pinkie124414273pinkie
pinko115618253pi_nko
pinks115729383pi_nks
pinky145823403pi_nky
pinnace113510313pinnace
pinnae84414643pinnae
pinnate93613743pinnate
pinole83218783pinole
pintle83818263pintle
pinwale1257843pinwale
pipages1289423pipages
pipal95118353pipa_l
pipals104213643pipals
pipe86434433pi__pe
pipeage1236203pipeage
pique16410173pi_que
piracy1339473piracy
pirana8713263pirana
pirated102515613pirated
pirates93020333pirates
piraya1167713piraya
piste75824603pi_ste
pita65436433pita__
pitas77427673pita_s
pitaya1186603pitaya
pixie145415523pi_xie
pizazz1554223pizazz
pizzle16279493pizzle
place94824613p_lace
plage84520403p_lage
plane74929143p_lane
plate74635113p_late
please84315733please
plicae10410953plica_e
plicate11314513plicate
pokable15209503pokable
poke105335363p__oke
pomace123111913pomace
pomade113611333pomade
potage92715903potage
prase76128753p_rase
prate75135983p_rate
prebake1539093prebake
primage12169143primage
primate111516283primate
private121513263private
psoae74411623psoa_e
puke105025463p__uke
pukka10457133puk_ka
pupae96515643pupa_e
pupate104213123pupate
quake184114643_quake
rake84841573__rake
remake124016113remake
retake104718533retake
rewake135218463rewake
rivage1038843rivage
sake85244963__sake
shake124726403_shake
shitake1455623shitake
sifaka1353553sifaka
sika86021323sika__
sikas94617023sika_s
sike87138783si__ke
silage72715303silage
silane62718053silane
sinkage1287263sinkage
skate94721553_skate
slake93724053_slake
snake94821113_snake
spake114322743_spake
spicae104313703spica_e
spicate113214193spicate
spike114922843spi__ke
spinage10289653spinage
spinate93114813spinate
splake1259783splake
stake95927533_stake
strake104017393strake
takahe1335793takahe
take84739263__take
tike85534483ti__ke
tikka835573tik_ka
tikkas934523tikkas
tilak91011553tilak_
tilaks1097353tilaks
tirade7311693tirade
tisane6311573tisane
ukase9428493_ukase
uncake122813523uncake
unmake122811213unmake
uptake1236963uptake
visage1049083visage
vitae84217633vita_e
vivace1436553vivace
wakame1535433wakame
wake114935703__wake
wickape1843723wickape

Search took 6 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 Limit1127162775.61020092.0
3Display Results2772770.0763644.7
 (SQL Overall)1786912775.82630671.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.