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

250 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
pikakes124582(None) 
pikake11115801pikake_
pickaxes2344912pickaxes
pikas114218092pika__s
pikes115031032pi__kes
pipages1289422pipages
pirates93020332pirates
alkanes113812933alkanes
awakes135012473_awakes
bakes117035373__bakes
berakes134815773berakes
betakes134212523betakes
biases84618433bi_ases
bifaces1448063bifaces
bikes117529473bi__kes
bikies124515163bik_ies
brakes124923123_brakes
cakes116037673__cakes
comakes154413643comakes
crakes124921813_crakes
dekares122710873dekares
dikes105831333di__kes
dilates83220663dilates
drakes114715863_drakes
eikones1137853eikones
epilates10313503epilates
epitases1038933epitases
fakes126032483__fakes
finales104016013finales
fixates1737393fixates
flakes134118873_flakes
hakes126034303__hakes
hikes125426983hi__kes
ikats95311153_ika_ts
images91411463_images
inanes62519803_inanes
intakes11310943intakes
irades74517393_irades
jakes165023643__jakes
kaes85734063__ka_es
kakas85117343__kakas
kakis86116843__kakis
kales95730983__kales
kames115024693__kames
kanes95529373__kanes
kikes85122553__kikes
kinases113511123kinases
kishkes1334773kishkes
lakes95737653__lakes
lianes63819323li_anes
ligases82310713ligases
ligates82318383ligates
likes96231903li__kes
linages8813173linages
linkages1385953linkages
lipases9209483lipases
makes115336853__makes
mikados1444683mikados
mikes115129893mi__kes
milages103114403milages
minkes124618783mi_nkes
mirages102213533mirages
mismakes16129883mismakes
mistakes141213413mistakes
nidates8311893nidates
opiates9312143opi_ates
paces96741113p__aces
packages17138733packages
pages85235073p__ages
palaces114216453palaces
palates93624933palates
pales75753803p__ales
pancakes1637073pancakes
panes76148693p__anes
parades104121463parades
parbakes1638343parbakes
pares77164483p__ares
parkades1538273parkades
partakes1449923partakes
pases75346503p__ases
pates76047893p__ates
pavanes123612653pavanes
paves104833923p__aves
paxes144928423p__axes
peaces106324083p_eaces
peages94321853p_eages
peaked136117403p_eaked
peaks114825623p_eak_s
peases85229473p_eases
pekans121710553peka_ns
pekes114623563p__ekes
pekoes124410423pek_oes
pelages10714613pelages
penates93321603penates
perukes133210113perukes
pesades10310903pesades
phages125213513p_hages
phases114618403p_hases
phrases12711463phrases
piaffes15115053piaffes
pianos84315933pi_anos
pians75126963pi_a_ns
pias66542553pi_a__s
pibals103813083piba_ls
picaras11311283picaras
picaros11310893picaros
picas94626523pica__s
pickaxe2244623pickaxe_
pickaxed2443513pickaxed
picked154421313pi_cked
picker144422173pi_cker
pickers153718093pi_ckers
picket144924313pi_cket
pickets154314183pi_ckets
pickles153215443pickles
picks135226143pi_ck_s
picrates122013213picrates
piddles114314273piddles
pieces104217273pi_eces
pierces113411193pierces
pies66949603pi___es
pieties9419223pieties
piffles15368763piffles
piggies113813483piggies
pigmies122610993pigmies
pika106322953pika___
pike106335213pi__ke_
piked125623313pi__ked
pikemen1535333pikemen
piker115622843pi__ker
pikers124717393pik_ers
pikis115116393pi__kis
pilaffs15365153pilaffs
pilafs113511023pila_fs
pilaus84114133pila_us
pilaws11399433pila_ws
piles74742613pi__les
pillages113012613pillages
pilules9510623pilules
pimas94725103pima__s
pimples133012423pimples
pinangs10267793pinangs
pinas75434453pina__s
pinatas93711503pinatas
pinches144117933pinches
pinenes93416673pinenes
pines76048863pi__nes
pingoes105116523pingoes
pinites9319533pinites
pinked134819883pi_nked
pinken124513283pi_nken
pinkens13419643pi_nkens
pinker125322443pi_nker
pinkers134118603pi_nkers
pinkest132812623pi_nkest
pinkey154314673pi_nkey
pinkeyes17335973pinkeyes
pinkeys16378213pi_nkeys
pinkies133818263pinkies
pinkoes135512313pinkoes
pinkos125313873pi_nkos
pinks115729383pi_nk_s
pinnaces12268863pinnaces
pinnies93318443pinnies
pinoles93418703pinoles
pinones94717073pinones
pintles94118723pintles
pintoes95117713pintoes
pinwales1367963pinwales
pipage1199143pipage_
pipals104213643pipa_ls
pipeages1336423pipeages
pipes96030143pi__pes
piques1739093pi_ques
piracies12312643piracies
piranas9912603piranas
pirate82322883pirate_
pirated102515613pirated
pirayas1277483pirayas
pishes114722103pi_shes
pisses84525083pi_sses
pistes85325633pi_stes
pitas77427673pita__s
pitayas1286263pitayas
pitches143617753pitches
pities83828083pi_ties
pixes144323173pi__xes
pixies154915513pi_xies
pizazzes1742373pizazzes
pizzazes1752513pizzazes
pizzles17329273pizzles
places104323703p_laces
plages94520153p_lages
planes85028083p_lanes
plates85432243p_lates
pleases94515483pleases
pokes116133013p__okes
pokies125921333pok_ies
pomaces132712123pomaces
pomades123711733pomades
potages102416423potages
prases84429023p_rases
prates84633163p_rates
praxes156215183p_raxes
prebakes1639013prebakes
primages13159273primages
primates121515933primates
privates131812373privates
pukes114523023p__ukes
pupates113311433pupates
quakes194013343_quakes
rakes94440353__rakes
remakes134116173remakes
retakes113718863retakes
rewakes144614983rewakes
rivages1138873rivages
sakes95540753__sakes
shakes135024593_shakes
shitakes1546113shitakes
sifakas1443333sifakas
sikas94617023sika__s
sikes96236083si__kes
silages82514443silages
silanes72517163silanes
sinkages1386853sinkages
skates104219403_skates
slakes104021883_slakes
snakes103919603_snakes
spikes124520713spi__kes
spinages11289293spinages
splakes1349673splakes
stakes103927293_stakes
strakes114218073strakes
takahes1436173takahes
takes94437793__takes
tikes95628903ti__kes
tikkas934523tik_kas
tilaks1097353tilak_s
tirades8311723tirades
tisanes7311853tisanes
ukases10358063_ukases
uncakes133012743uncakes
unmakes132810793unmakes
uptakes1336593uptakes
visages1138693visages
vivaces1536413vivaces
wakames1635283wakames
wakes126633653__wakes
wickapes1943703wickapes
yikes125117753yi__kes

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272506.22021547.7
3Display Results2502500.0763289.5
 (SQL Overall)1786912506.70226662.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.