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

155 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
periques193766(None) 
perique1837521perique_
beziques2843212beziques
perdues103511332per_dues
perigees1189502perigees
perilunes1147172perilunes
perishes13313752perishes
peritus9311802peritu_s
piques1739092p__iques
piroques1944352piroques
reliques1736902reliques
aeries64737783aeri__es
aerifies111313393aerifies
antiques1738893antiques
aperies9423203aperi__es
appliques2242553appliques
baroques1934863baroques
barques18259643bar_ques
berimes115216643beri_mes
bezique2743173bezique_
briquet1838833_briquet
briquets1934853_briquets
caciques21165373caciques
caiques18248793_caiques
caziques28193773caziques
cerises94722253ceri_ses
cerites94823433ceri_tes
ceriums1139483ceri_ums
cirques1836463cir_ques
cliques18309203_cliques
derides93420853deri_des
derives114017813deri_ves
detinues9569823detinues
ferities111416723ferities
fiques1837973__fiques
garigues1034963garigues
heniquen2042883heniquen
heniquens2142503heniquens
laliques1744833laliques
marques182610863mar_ques
meringues1244393meringues
merises93421423meri_ses
obliques1944533obliques
paraquet1948793paraquet
paraquets2044603paraquets
paries84742523pari__es
parietes10714553parietes
parises94827193pari_ses
parishes13314763parishes
parities10522983parities
paroquet1947283paroquet
paroquets2043653paroquets
parquet18311583par_quet
parquets1936423par_quets
pedicles1338683pedicles
pedicures1445263pedicures
peeries93623023peeri__es
peises84125043pe_i_ses
pelisses1048483pelisses
pelites93821993peli_tes
penises9318193peni_ses
percales12313803percales
perches143717953per_ches
percuss1137163per_cuss
perdue93912633per_due_
perdures11289683perdures
perdus93711273per_du_s
peres76246643per___es
perfidies1546603perfidies
perfumes1555893perfumes
perfuse1247663per_fuse
perfuses1358663perfuses
periapses1346053periapses
periapts1237273periapts
periblem1445513periblem
periblems1543493periblems
pericopes1547873pericopes
peridots1138323peridots
perigee101113393peri_gee
perigons11310083perigons
periled10316323peri_led
perillas10310833perillas
perilled11410113perilled
perilous10310693perilous
perils84121853peri__ls
perilune1046993perilune
perinea9313043peri_nea
perineum1246523perineum
periods10312243peri_ods
peripter1278753peripter
peripters1368123peripters
peris75537073peri___s
perished14310093perished
periwigs1444193periwigs
perjures17268083perjures
perlites10316363perlites
permutes1238713permutes
perniones1148593perniones
perries93226603per_ries
perses85428063per__ses
perukes133210113per_ukes
peruse84016843per__use
peruses94018163per_uses
pervades1437353pervades
pervious1337543perviou_s
petioles10311643petioles
petites93820203peti_tes
petrifies14310363petrifies
physiques2641703physiques
pique16410173p__ique_
piqued1836213p__iqued
piquet17412353p__iquet
piquets1836603p__iquets
pirogues1135473pirogues
piroque1844353piroque_
plaques18317893p_laques
postiques2045833postiques
pratiques20114223pratiques
prequel1836343p_requel
prequels1934833p_requels
prerinses1138813prerinses
prevues1239263p_revues
prices104524543p_ri_ces
prides94324183p_ri_des
pries74339533p_ri__es
primes104225263p_ri_mes
primus103712173p_rimu_s
primuses1237083p_rimuses
princes113015153p_rinces
prises84133173p_ri_ses
prisses94816713p_risses
privies122414263p_rivies
prizes173819813p_ri_zes
pulques1835323p_ulques
purifies13311933purifies
purines94420773puri_nes
purities10316283purities
pursues94111373pur_sues
pyrites12812203pyri_tes
relique1636823relique_
rerises73525883reri_ses
residues9338813residues
retinues85113153retinues
roques154912563__roques
seriates82620683seriates
series64540973seri__es
serines74229543seri_nes
serious73616283seriou_s
siliques1745353siliques
torques16217513tor_ques
uniques1667443_uniques
verifies141313483verifies
verites103822263veri_tes
verities111418043verities
yperites13310153yperi_tes

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621557.97018339.0
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.43921174.4
 
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.