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

174 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
pirayas127748(None) 
piranas9912601piranas
piraya1167711piraya_
pitayas1286261pitayas
papayas1437272papayas
picaras11311272picaras
pinatas93711482pinatas
piraguas1144452piraguas
pirana8713262pirana_
piranhas13135872piranhas
pirates93020322pirates
pitaya1186602pitaya_
playas114612282p_layas
prays105022432p_ray_s
puranas9712642puranas
rayas85922052__rayas
spiraeas10286232spiraeas
abayas114011703_abayas
airways1336243airway_s
arrayal1055843arrayal
arrayals1154483arrayals
arrays95311683array_s
asramas938303asramas
bravas114913323_bravas
brays106723113_bray_s
brazas175812433_brazas
cicadas1235983cicadas
cicalas1139293cicalas
curaras93911943curaras
derays105514253deray_s
dioramas1145503dioramas
dirams94413703dira_ms
dramas95814653_dramas
drays95819773_dray_s
erratas736843erratas
forays124813003foray_s
fracas11311993_fracas
frays116920103_fray_s
gramas94317203_gramas
grays95621333_gray_s
irades74517393_irades
jicamas1845043jicamas
kabayas16316803kabayas
kinaras1159093kinaras
lianas63713383li_anas
liras56021983lir__as
maracas11313773maracas
mayas105924383__mayas
mirages102213533mirages
mirzas1738173mir_zas
morays114613883moray_s
nirvanas1142513nirvanas
pacas96029403p__acas
paisanas10288873paisanas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
papas94927493p__apas
papaya1337503papaya_
papayan1445303papayan
parades104121463parades
parados103816053parados
paramos113213513paramos
parangs104314373parangs
paraphs1439313paraphs
paras76143043p__aras
parkas125018023par_kas
parlays123910453parlay_s
paruras9310533paruras
patacas11311003patacas
pays95940223p__ay_s
phrasal1246163phrasal
phrases12711463phrases
pianos84315933pi_anos
pians75126963pi_a_ns
pias66542553pi___as
piasabas1243883piasabas
piasavas1343333piasavas
piazzas1743643piazzas
pibals103813083piba_ls
picara10311903picara_
picaros11310893picaros
picas94626523pi__cas
picrates122013203picrates
pietas84516503pi_etas
pikakes1245823pikakes
pikas114218093pi__kas
pilaffs15365153pilaffs
pilafs113511023pila_fs
pilaus84114133pila_us
pilaws11399433pila_ws
pimas94725103pi__mas
pinangs10267793pinangs
pinas75434453pi__nas
pinata83817213pinata_
pinnas85315513pi_nnas
pintadas11105063pintadas
pintas85021393pi_ntas
pipages1289423pipages
pipals104213643pipa_ls
piracies12312643piracies
piracy1339473pira_cy
piragua1044643piragua
piranha12126363piranha
pirate82322883pira_te
pirated102515613pirated
piratic11314293piratic
pirns76020093pir__ns
pitahayas1751493pitahayas
pitapat1149163pitapat
pitapats1244443pitapats
pitas77427673pi__tas
pittas86014523pi_ttas
pizzas1646983pi_zzas
playa105812943p_laya_
plays106320773p_lay_s
plazas17409913p_lazas
posadas1037193posadas
praam94815613p_ra_am
praams10459643p_raams
prahus11458243p_rahus
prajnas1635453p_rajnas
prams96125513p_ra_ms
prangs94816233p_rangs
pranks124814723p_ranks
praos74923563p_ra_os
prases84429023p_rases
prates84633163p_rates
prats76333393p_ra_ts
praus74621753p_ra_us
prawns11509023p_rawns
praxes156215183p_raxes
praxis154012253p_raxis
pray96331533p_ray__
prayed124815433p_rayed
prayer114815293p_rayer
prayers124212853p_rayers
preys105717783p_rey_s
priapus1134353priapus
primas104418103p_rimas
proas75028803p_r_oas
purana8712933purana_
purdas92612263pur_das
pyas96225703p___yas
pyjamas21263523pyjamas
pyrans11411063pyra_ns
pyrolas1239863pyrolas
ragas65326063__ragas
raias54631123__raias
rajas127317723__rajas
raya75224823__raya_
rayah116013503__rayah
rayahs12579193__rayahs
rays77642353__ray_s
riatas63915083ri_atas
ryas77224613__r_yas
sifakas1443333sifakas
sirras63814863sir_ras
spiraea9407983spiraea_
spirals93212513spira_ls
spirants1088283spirants
spireas94412513spir_eas
spirulas10207203spirulas
sprays115913643spray_s
stratas73013573stratas
strays96417933stray_s
taramas9612693taramas
tiaras6314533ti_aras
tirades8311723tirades
trays85623433_tray_s
viragos1146713viragos
virgas1048883vir_gas
zirams17438643zira_ms

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.1701051123.5
2DLD Change Limit1340271747.53317792.0
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.76623009.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.