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

205 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
pervade133702(None) 
pervaded1535371pervaded
pervader1444861pervader
pervades1437351pervades
evade938182_e_vade
nervate1039532nervate
parade94720642par_ade
parkade1437582parkade
percale11314092percale
persuade1145852persuade
pervaders1544432pervaders
pesade9311102pe_sade
prebade12310282prebade
prefade1339012prefade
premade12311442premade
abrade9313053abr_ade
acervate1336983acervate
aerate64830553aer_ate
arcade91013643_arcade
berake124216083ber_ake
berate84729023ber_ate
bereave1258353bereave
cerate84829463cer_ate
cervid1239323cervid_
cervine122610803cervine
corrade101111043corrade
couvade1335063couvade
decade104216163de_cade
degrade10229903degrade
derate74531233der_ate
deride84420033der_ide
derivate12311203derivate
enervate1148463enervate
erase54925493_er_ase
ergate7315143_ergate
erode64520993_er_ode
evaded1137063_e_vaded
evader1036813_e_vader
evades1039023_e_vades
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
fervid1337513fervid_
forbade13259103forbade
germane1049663germane
grade75126093_gr_ade
grenade938413grenade
herbage1337003herbage
hermae115314473herma_e
hexade17438903he_xade
invade10157853_invade
irade65618153_ir_ade
larvae938843larva_e
merde84320123mer__de
nerve86617373nerv__e
nerved104111683nerved_
nervine102510633nervine
nervule1044943nervule
nervure1034973nervure
operate9615733oper_ate
overlade12611553overlade
paraded114014263par_aded
parader103914863par_ader
parades104121463par_ades
parae76335703par_a_e
paravane1348103paravane
parbake1538353parbake
parkades1538273parkades
partake1339643partake
parve109824853parv__e
parvise124211693parvise
passade1039233passade
pavane114113443p_avane
peace95026083pe__ace
peage84723573pe__age
pease75231113pe__ase
pectase112410363pectase
pectate112214693pectate
pedate93117763pe_date
peerage1089803peerage
peeve104915253peev__e
peeved124112893peeved_
pelage9515363pe_lage
peltate92013773peltate
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentad9313763pentad_
pentads1039523pentads
pentane9415743pentane
pentode1039893pentode
peonage1048723peonage
peptide122910683peptide
percales12313803percales
perched154713243perched
perdie94718513per_die
perdu84216273per__du
perdue93912633per_due
perdure10379623perdure
perdy115417333per__dy
pere66450263per___e
perea75026443perea__
perfidy1635273perfidy
perfume1446503perfume
perfuse1247663perfuse
perhaps1446123perhaps
periapt11313413periapt
perigee101113393perigee
periled10316323periled
period9314983period_
periods10312243periods
perique1837523perique
perjure16327963perjure
perked134617693perked_
perlite9317323perlite
permease1246503permease
permeate12311613permeate
permed115217353permed_
permute1138793permute
pernod9310453pernod_
pernods1038483pernods
perorate10417923perorate
peroxide1848183peroxide
persalt9315413persalt
perse75429523per__se
persuaded1344373persuaded
persuader1244263persuader
persuades1245623persuades
pertain92714963pertain
peruke123210393per_uke
peruked14367893peruked
peruse84016843per_use
perused103112193perused
perv97224813perv___
pervading1636303pervading
pervasive1744483pervasive
perverse1336103perverse
pervert12315583pervert
pervs105117373perv__s
pesades10310903pe_sades
petrale9312623petrale
phrase11109903phr_ase
pirate82322883pir_ate
pomade113611333p_omade
portage103013643portage
prase76128753p_r_ase
prate75135983p_r_ate
prebake1539093prebake
precede1239653precede
precode12311853precode
predate10616893predate
preface14510923preface
prefaded1537823prefaded
prefades1439533prefades
pregame1239553pregame
prelate9519693prelate
prelude1038013prelude
prename11412643prename
prepare111913623prepare
prepave14228873prepave
prerace11414123prerace
presage10312293presage
presale9416353presale
preside10715613preside
pretape113511623pretape
prevail1238243prevail
prevalue1345073prevalue
previse123713793previse
prevue1179163prev_ue
prevued1337143prevued
pride84724733p_r_ide
private121513263private
provide1339853provide
prude84615973p_r_ude
pyruvate1643073pyruvate
regrade92612033regrade
reinvade1244503reinvade
remade94316983re_made
reread71715433reread_
rereads81512293rereads
respade1039573respade
selvage1136553selvage
serape84818413ser_ape
serenade9218343serenade
serfage1138403serfage
seriate73722473seriate
serrate73017543serrate
servable13310093servable
serval93913413serva_l
servals103410743servals
servant10313633servant
serve85425963serv__e
served104616813served_
service1239093service
servile10310643servile
ternate7415483ternate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
tirade7311693tir_ade
torsade837593torsade
trade65026043_tr_ade
upgrade11215823upgr_ade
vervain1335563vervain
verve115417723verv__e

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 Limit1340272056.48320673.6
3Display Results2052050.0802562.5
 (SQL Overall)1786912056.96925640.8
 
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.