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

182 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
perhaps144612(None) 
pechans14810502pechans
perhapses1644152perhapses
periapt11313412periapt
periapts1237272periapts
perps95521482per__ps
petnaps1145032petnaps
aerials74017563aerials
arhats9312983_arhats
barhops14288113barhops
becaps123811403be_caps
beleaps1138053beleaps
berthas12398763bertha_s
bewraps14135403bewraps
burlaps1156253burlaps
carhops14329703carhops
cereals9313173cereals
cerias83321983ceria_s
chaps125326063__chaps
craps95328643_cr_aps
derats74625063der_ats
derays105514253der_ays
dermas94116823derma_s
dewlaps1334663dewlaps
dirhams13376313dirhams
earlaps936393earlaps
ephahs1435503_ephahs
ephas10311543_epha_s
eras45441503_er_a_s
ferals94216643fer_als
ferbams1435743ferbams
ferias95020393feria_s
fraps105620553_fr_aps
gelcaps1235203gelcaps
gerahs1039413ger_ahs
germans1079473germans
haps96443463___haps
heaps105223223he__aps
heehaws1643363heehaws
herbals122710613herbals
jehads1735833je_hads
leaps75522933le__aps
lethals1038113lethals
mishaps1438723mishaps
neaps75618323ne__aps
operas8312453oper_a_s
overheaps17226953overheaps
overlaps13219523overlaps
pachas135017143pacha_s
paps86443453p___aps
paraph13311263par_aph
paraphs1439313par_aphs
paras76143053par_a_s
pardahs13289673pardahs
pariahs123812343pariahs
parians93519743parians
parkas125018033parka_s
parlays123910453parlays
parrals94414573parrals
partans94418283partans
pashas115117063pasha_s
peags86122843pe__ags
peahens12307573peahens
peaks114825623pe__aks
peals75235493pe__als
peans75437643pe__ans
pears75138613pe__ars
peas65755063pe__a_s
peats76140193pe__ats
pecans101515833pe_cans
pechan13511543pecha_n
pechs125516203pech__s
pedals94316033pe_dals
pedlars103210213pedlars
peeps95822363pe__eps
pehs95625763pe_h__s
pekans121710553pe_kans
pentads1039523pentads
peps85134513pe___ps
percale11314093percale
percales12313803percales
percept133112523percept
percepts14247643percepts
perchers153611523perchers
perches143717953perches
percuss1137163percuss
perdues103511333perdues
perdus93711273per_dus
perea75026443perea__
pereons92815003pereons
peres76246643per__es
periapses1346053periapses
periapsis1344833periapsis
pericarps1544473pericarps
perils84121853per_ils
periods10312243periods
peris75537073per__is
peritus9311803peritus
perks115325803per__ks
permits11314003permits
perms95524513per__ms
pernods1038483pernods
perp89029893per__p_
perries93226603perries
perrons93115483perrons
persalt9315413persalt
persalts1038193persalts
perses85428063per_ses
persons93717013persons
pertain92714963pertain
pertains102113423pertains
perukes133210113perukes
perusals1047143perusals
peruses94018163peruses
pervade1337023pervade
pervades1437353pervades
pervs105117373per__vs
petals84719813pe_tals
petnap1037423petnap_
petsais938433petsais
phreaks1634543phreaks
portals94015563portals
praams10459643p_raams
prahus11458243p_rahus
prams96125513p_r_ams
praos74923563p_r_aos
prats76333393p_r_ats
praus74621753p_r_aus
prays105022433p_r_ays
preamps1336613preamps
prefabs1435163prefabs
preheats1339423preheats
preops104911943p_reops
prepays1437483prepays
preps96220693p_r_eps
preshape1537533preshape
preshapes1667093preshapes
preships1539313preships
pretape113511623pretape
pretapes122811533pretapes
prewraps15114053prewraps
priapi1037923p_riapi
priapus1134353p_riapus
primps124711823p_rimps
proas75028803p_roa_s
props95726883p_r_ops
pshaws14435703p_shaws
purdahs13285483purdahs
purdas92612263purda_s
pushups1433653pushups
pyrans11411063pyr_ans
raps66247733__r_aps
reaps75626193__reaps
recaps103615733re_caps
redcaps1247073redcaps
rehabs1139023re_habs
remaps105012873re_maps
rereads81512293rereads
reshape1249043reshape
reshapes1338803reshapes
reships1239863reships
rewraps12136563rewraps
scraps106017243scr_aps
seracs84418573ser_acs
serais64326133ser_ais
serape84818413ser_ape
serapes95218103ser_apes
seraph114011163ser_aph
seraphs12408093ser_aphs
serdabs1035323serdabs
serials73919753serials
servals103410753servals
straps87721783str_aps
terais64023513ter_ais
teraph11319093ter_aph
terras63516973terra_s
threaps12488643threaps
traps75727483_tr_aps
verbals121910743verbals
whaps135115163__whaps
wraps105617153_wr_aps
yerbas11119293yerba_s

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.423422437.4
2DLD Change Limit1340271826.04622167.9
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.53227356.2
 
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.