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

220 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
prelude103801(None) 
preclude1344901preclude
preluded1236471preluded
preluder1135731preluder
preludes1137831preludes
delude81910672_delude
elude64517622__elude
prebade12310282prebade
precede1239652precede
precluded1544222precluded
precludes1445052precludes
precode12311852precode
precure11312552precure
prefade1339012prefade
preguide1255422preguide
prejudge1943202prejudge
prelate9519692prelate
prelife1279942prelife
preluders1234422preluders
premade12311442premade
premune1138932premune
prepuce1337832prepuce
preside10715612preside
presume11310302presume
prevue1179162prevu_e
prevued1337142prevued
prude84615972pr__ude
relume8313272_relume
allude73910903_allude
brede85520503bre__de
collude10337993collude
crude86018573cr__ude
deluded10158763_deluded
deluder9168333_deluder
deludes91810643_deludes
deluge8189403_deluge
deluxe14197303_deluxe
denude8169353_denude
elide64922643__elide
eluded84612773__eluded
eluder73712213__eluder
eludes75417683__eludes
elute54822573__elute
etude63612303__etude
exclude1744453exclude
exude134010293__exude
grenade938413grenade
illude7327503_illude
include1036083include
lude55331643___lude
occlude1263183occlude
oreide7311673ore_ide
peeled94119713peeled_
pelage9515363p_elage
pele65539553p_el__e
pelite84323003p_elite
pelted94617763p_elted
perdue93912633perdu_e
perdure10379623perdure
perfume1446503perfume
perfuse1247663perfuse
perilune1046983perilune
perjure16327963perjure
perlite9317323perlite
permute1138793permute
persuade1145853persuade
peruke123210393p_eruke
peruse84016843p_eruse
pervade1337023pervade
pesade9311103p_esade
pilule8411123p_ilule
plume94819463p__lume
pollute937383pollute
postlude1144543postlude
praline93019743praline
preaged11612333preaged
preaudit1177023preaudit
prebake1539093prebake
prebid113512843prebid_
prebids12399883prebids
prebudget1544073prebudget
prebuy1357423prebu_y
prebuys1444393prebuys
preceded1438293preceded
precedes13310713precedes
precipe133012123precipe
precise113518173precise
precoded1438863precoded
precodes13711573precodes
precured1339993precured
precures12312903precures
precut102016533precu_t
precuts111710473precuts
predate10616893predate
predive13511083predive
predusk1443773predusk
pree67044733pre___e
preed85128123pre_ed_
preemie11310563preemie
preened103214993preened
preface14510923preface
prefaded1537823prefaded
prefades1439533prefades
prefile123413183prefile
prefire124012813prefire
preflame1545913preflame
prefund1335733prefund
prefunded1644693prefunded
prefunds1454693prefunds
pregame1239553pregame
preguided1443923preguided
preguides1344863preguides
prejudged2142753prejudged
prejudger2042553prejudger
prejudges2043133prejudges
prejudice2143343prejudice
prelacy1437583prelacy
prelates10418573prelates
prelature1146263prelature
prelaw1139103prel_aw
prelect111013833prelect
prelim10311423prel_im
prelims1139823prelims
prelives13310383prelives
preload1049813preload
preloaded1335923preloaded
preloads1157513preloads
preludial1244873preludial
preluding1337053preluding
prelunch1543433prelunch
prelusive1455583prelusive
premed114617763premed_
premeds12389593premeds
premie103617993pre_mie
premise113818553premise
prename11412643prename
preorder1136463preorder
prepare111913623prepare
prepave14228873prepave
preplace1488983preplace
prepped11329903prepped
preppie1058093preppie
prepubes1436053prepubes
prepuces1438583prepuces
prepupa1064023prepupa
prepupae1144643prepupae
prequel1836343prequel
prerace11414123prerace
presage10312293presage
presale9416353presale
prese75228383pre__se
presided12410553presided
presider11410423presider
presides11414913presides
preslice1258623preslice
pressed103317313pressed
pressure1039773pressure
presumed1337973presumed
presumer1247583presumer
presumes1239843presumes
pretape113511623pretape
pretype14387483pretype
prevalue1345073prevalu_e
prevalued1544553prevalued
previse123713793previse
prevues1239263prevues
prewire124311143prewire
preyed125313203preyed_
pride84724733pr__ide
prilled104713003prilled
procure1138573procure
produce1267513produce
profuse1237153profuse
prolate9419793prolate
prole74527793prol__e
proline92321593proline
protrude1144703protrude
proud84615483pr_oud_
prouder10310383pr_ouder
provide1339853provide
prudes94215443pr__udes
prune75119633pr__une
pseud867043pse_ud_
pseudo934713pse_udo
pseuds944793pse_uds
rebuke124010123_rebuke
recede95515533_recede
recluse95210773_recluse
recode93618713_recode
recuse85519163_recuse
rede55037673_re__de
reduce9713253_reduce
refuge105312613_refuge
refuse94817513_refuse
refute95515703_refute
reglue739703_reglu_e
reglued936333_reglued
rejudge1634023_rejudge
relace83122153_relace
relate64033633_relate
releve95116403_releve
relied74926233_relied
reline65434353_reline
relive95120783_relive
reluct83916113_reluct
relumed1069813_relumed
relumes9612513_relumes
remade94316983_remade
remuda936823_remuda
repute84716093_repute
reside74224933_reside
resume8313783_resume
retune69121953_retune
retuse66617223_retuse
reuse56025363_re_use
revue81114453_revu_e
rude55632783_r__ude
seclude1035233seclude
ureide7310363ure_ide
velure939773_velure

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.406440125.6
2DLD Change Limit1340272206.58020368.8
3Display Results2202200.0762894.7
 (SQL Overall)1786912207.06225303.2
 
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.