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

215 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
pitaya118660(None) 
piraya1167711piraya
pitayas1286261pitayas
papaya1337502papaya
pataca10311192pataca
picara10311902picara
pinata83817222pinata
pintada1096082pintada
pirana8713262pirana
pirayas1277482pirayas
pita65436442pit__a
pitahaya1641842pitahaya
pitapat1149162pitapat
pitas77427672pita_s
pithy135614462pithy_
pitta75018692pit_ta
pity96031942pit_y_
playa105812942p_laya
abaya104413173_abaya
bitsy104511303bitsy_
bitty106119173bitty_
cicada1136413cicada
cicala10310063cicala
cithara12166513cithara
citola838393citola
city95122633cit_y_
dita56032533dit__a
ditas65923673dita_s
ditsy95612563ditsy_
ditty95019293ditty_
ditzy186513283ditzy_
epitaph1444133epitaph
epitaxy1963563epitaxy
fitly115114973fitly_
gitano738043gitano
jicama1734883jicama
kabaya15387123kabaya
kinara10310373kinara
kithara14145193kithara
kitty124614573kitty_
liana53915893li_ana
litai55216363lita_i
litany939053litany
litas54923773lita_s
lithia939333lithia
maya95824593__maya
mity95528223mit_y_
nitty85418313nitty_
ottava963683ottava
paca85132243p__aca
paisana94010233paisana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213353panama
papa85827143p__apa
papayan1445303papayan
papayas1437273papayas
para65242183p__ara
patacas11311003patacas
patagia1068783patagia
patamar1147093patamar
patina86022193patina
patly105020583patly_
patsy105717203patsy_
patty104723613patty_
paty95234563pat_y_
pay88461183p__ay_
pays95940223p__ays
peaty105725693peaty_
petal76526893peta_l
petals84719813petals
petard95013803petard
petty105320293petty_
pia56848043pi___a
pial65636713pi_a_l
pian66136103pi_a_n
piano76118713pi_ano
pians75126963pi_ans
pias66542563pi_a_s
piasaba1144193piasaba
piasava1243883piasava
piazza1643823piazza
pibal95217323piba_l
pibals103813083pibals
pica85831503pi__ca
pical95524373pica_l
picaras11311283picaras
picaro10311323picaro
picas94626523pica_s
piccata1345703piccata
picky165416943picky_
pieta75421753pi_eta
pietas84516503pieta_s
piety105817303piety_
piggy124011433piggy_
pigmy13299433pigmy_
pigtail1046623pigtail
pika106322963pi__ka
pikake11115803pikake
pikas114218093pika_s
pilaf103923483pila_f
pilaff143910363pilaff
pilafs113511023pilafs
pilar75221503pila_r
pilau73618523pila_u
pilaus84114133pilaus
pilaw103913743pila_w
pilaws11399433pilaws
pilea75123953pi_lea
pily96132743pi_ly_
pima85428663pi__ma
pimas94725103pima_s
pina65842643pi__na
pinang92611593pinang
pinas75434453pina_s
pinatas93711503pinatas
pineta85815563pineta
piney105727503piney_
pinky145823403pinky_
pinna75320183pi_nna
pinny105222063pinny_
pinta75727053pi_nta
pintadas11105083pintadas
pintado1096573pintado
pintail9311183pintail
pintano998993pintano
pintas85021393pinta_s
piny911838363pi_ny_
pipage1199143pipage
pipal95118353pipa_l
pipals104213643pipals
pipy115421523pi_py_
piracy1339473piracy
piragua1044643piragua
piranas9912613piranas
piranha12126363piranha
pirate82322883pirate
pit56471933pit___
pitahayas1751493pitahayas
pitapats1244443pitapats
pitch125018413pit_ch
pitchy16479673pitchy
pitfall1245823pitfall
pith95432703pit__h
pithead13419593pithead
pithed124615613pithed
piths105817543pit_hs
pitied94017253pitied
pitier84019823pitier
pities83828083pities
pitman102412123pitman
pitmans11188743pitmans
pitmen102510793pitmen
piton76121583pit_on
pitons85319043pitons
pits66348753pit__s
pitsaw1135613pitsaw
pitsaws1234993pitsaws
pittas86014523pittas
pitted94319593pitted
pixy166117773pi_xy_
pizazz1554223pizazz
pizza1538183pi_zza
platy105021663platy_
platys11459853platys
play95928983p_lay_
playas114612283p_layas
plays106320773p_lays
plaza164311063p_laza
posada937163posada
potage92715903potage
potash1138273potash
potato8513433potato
potsy105815613potsy_
potty105621003potty_
pray96331533p_ray_
prays105022433p_rays
purana8712933purana
putty104721403putty_
pya87023753p___ya
pyjama20303483pyjama
raya75224823__raya
riata54618023ri_ata
ritard74812083ritard
ritzy175611163ritzy_
satara6315533satara
satay84718463satay_
satays94411683satays
sifaka1353553sifaka
sitar54820543sita_r
sitars65417593sitars
spiraea9407983spiraea
spital83813873spita_l
spitals93011593spitals
stay78333723_stay_
stays86022023_stays
taka87623593__taka
tala45938053__tala
tapa65129153__tapa
taxa116820103__taxa
tiara5315913ti_ara
titan53318173tita_n
titania738293titania
titans63414913titans
titty85316653titty_
vita75828533vit__a
vitae84217633vita_e
vital84819673vita_l
vitals94514303vitals
vitta85015173vit_ta
witan83816503wita_n
witans93412933witans
withy144813763withy_
witty114717013witty_

Search took 10 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.546327272.9
2DLD Change Limit1127162158.78312833.4
3Display Results2152150.343626.8
 (SQL Overall)1786912159.67218475.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.