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 “prefight” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

472 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
prefight174639(None) 
preflight1844671preflight
refight1488871_refight
firefight1944132firefight
freight1447602fre_ight
preflights1943322preflights
prizefight2851512prizefight
refights1555882_refights
relight11512062_relight
resight11510642_resight
aright103817663ar__ight
bedight1437483_bedight
bright124215923br__ight
catfight1744273catfight
delight12610673_delight
dogfight1742993dogfight
dreigh11246443dre_igh_
eight94928053__e_ight
eyesight1543523eyesight
fight124027093___fight
firefights2043313firefights
firelight1655533firelight
foresight1645323foresight
freights1555853fre_ights
fright133715243fr__ight
gunfight1643493gunfight
height134713433_he_ight
infight1437453_infight
outfight1546103outfight
penlight1446423penlight
plight123513363p__light
prebirth1543463prebirth
prebought17113153prebought
precinct1459423precinct
predict12315323predi_ct
predigest1357633predigest
prefect141011073pref_ect
prefigure1544043prefigure
prefile123413183prefi_le
prefiled143310573prefiled
prefiles133113443prefiles
prefire124012813prefi_re
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi__x
prefixal2044543prefixal
prefixed21357703prefixed
prefixes20389233prefixes
preflighted2172783preflighted
prelimit1259123prelimit
premixt183510663premi_xt
preriot9316413preri_ot
presift12312223presi_ft
previsit13410073previsit
preweigh1753683preweigh_
preweighs1872713preweighs
prizefights2951293prizefights
profit113016273profi__t
refit84230063_refi__t
refought1564243_refought
relights1248053_relights
resights1246733_resights
right94430503_r__ight
sleight11279023sle_ight
spright132010403spr__ight
upright13178293upr__ight
weight133914183_we_ight
wright133713513wr__ight
affright1844194affright
airtight1245974airtight
alight103816864__alight
alright1148854_alright
aweigh1334934awe_igh_
barefit1249724barefi__t
bedights1544744_bedights
beefiest13269014beefiest
befit105222664_befi__t
beknight1843564beknight
bight118728844___bight
blight124114624__blight
brights133710234br__ights
brought13308694br_ought
bullfight1842934bullfight
catfights1842794catfights
cockfight2452634cockfight
credit9315194credi__t
crepiest12310384crepiest
daylight1644514daylight
defiant11311924_defiant
deficit1339684_deficit
delights1347334_delights
dight104027004___dight
dogfights1842034dogfights
draught12266984dr_aught
dreich12377724dre_ich_
droplight1643804droplight
drought12258884dr_ought
eighth133310604__e_ighth
eights103618984__e_ights
eighty133711604__e_ighty
eyebright1852034eyebright
eyesights1642204eyesights
fanlight1545844fanlight
fights133816554___fights
firefighter2172034firefighter
firelights1764014firelights
fistfight1952864fistfight
flight134014814__flight
foresights1743754foresights
fortnight1643804fortnight
fraught14266364fr_aught
freighted1755204fre_ighted
freighter1655024fre_ighter
frights14339624fr__ights
gaslight1395344gaslight
gastight1365214gastight
greenlight1552734greenlight
greige847204gre_ig_e
greiges937734gre_iges
greyish1435174greyish_
gunfights1742434gunfights
heigh124812544_he_igh_
heighth13366344_he_ighth
heights14399444_he_ights
hight125327234___hight
infights1545574_infights
inflight1545894inflight
insight1137914_insight
knight1438174__knight
light94429604___light
limelight1544244limelight
lowlight1554944lowlight
midnight1544494midnight
might113827084___might
mislight1447244mislight
neigh94912384_ne_igh_
neighs10387734_ne_ighs
night94327854___night
oiltight1244544oiltight
outfights1643784outfights
outright1248744outright
outsight1246914outsight
overflight2044444overflight
overlight1647794overlight
overnight1646774overnight
oversight1647634oversight
overtight1647624overtight
panfish15229974panfish_
peevish1535784peevish_
peewit111110904peewi__t
penlights1544204penlights
perfect141010834perf_ect
perfidy1635274perfi_dy
periapt11313414p_eriapt
peridot10514244p_eridot
perigee101113394p_erigee
perigon1039854p_erigon
perish114619064p_erish_
perkiest143313244perkiest
perkish16258824perkish_
permit10321684permi__t
persist9315854persi_st
petit74332654p_eti__t
pewit104622794p_ewi__t
piefort1249534pief_ort
pietist9414034pieti_st
pigfish16217174pigfish_
pinfish15319304pinfish_
pipefish1844534pipefish_
pledget113510654ple_dget
plenish1239944plenish_
plenist9314334pleni_st
plights13299314p__lights
postflight1953094postflight
praefect1544774praef_ect
preach133613924pre_ach_
preachy17307314pre_achy
preact103220394pre__act
preadapt1346864preadapt
preadmit1346814preadmit
preadopt1348314preadopt
preadult1146974preadult
preaged11612334pre_aged
preallot1047034preallot
preaudit1177024preaudit
prebid113512844prebi__d
prebids12399884prebi_ds
prebill1138804prebi_ll
prebills1237294prebills
prebind123810644prebi_nd
prebinds13357734prebinds
prebirths1642154prebirths
prebudget1544074prebudget
prebuilt1247034prebuilt
precast11314854pre_cast
precent113520264pre_cent
precept133112514pre_cept
precieux1943034precieux
precincts1544994precincts
precious12310594precious
precipe133012124preci_pe
precipes143212214precipes
precis103416704preci__s
precise113518174preci_se
precised133213414precised
preciser123411664preciser
precises123218334precises
precisest13259004precisest
precited133013814precited
precut102016534pre__cut
predeath1447004predeath
predial103815414predi_al
predicant1449394predicant
predicate14411784predicate
predicts1339614predicts
predigests1443664predigests
predive13511084predi_ve
predraft1447594predraft
preedit10512464pre_edit
preeing103817674preei_ng
preelect1249644preelect
preempt1337724pre_empt
preenact12410184preenact
preerect1259274preerect
preexist1747964preexist
prefab1336244pref__ab
prefabs1435164pref_abs
preface14510924pref_ace
prefaced1638424prefaced
prefacer1537984prefacer
prefaces15311064prefaces
prefade1339014pref_ade
prefaded1537824prefaded
prefades1439534prefades
prefects1598134prefects
prefer113813204pref__er
prefers123713334pref_ers
prefigured1743314prefigured
prefigures1643904prefigures
prefiling1549534prefiling
prefilled1535514prefilled
prefiring1559074prefiring
prefixing2246784prefixing
prefixion2144114prefixion
preflame1545914preflame
preflighting2252654preflighting
prefocus1544744prefocus
preform1439614pref_orm
preformat1646364preformat
preforms1537404preforms
prefrank1764234prefrank
prefroze2264674prefroze
prefund1335734pref_und
prefunds1454694prefunds
pregnant1149884pregnant
preheat12413894pre_heat
prelect111013834pre_lect
prelegal1145054prelegal
prelife1279944preli_fe
prelim10311424preli__m
prelimits1366014prelimits
prelims1139824preli_ms
prelives13310384prelives
premeet11615154pre_meet
premie103617994premi__e
premier113515634premi_er
premiere12249234premiere
premiers122911654premiers
premies113823064premi_es
premise113818554premi_se
premised133013194premised
premises123018274premises
premiss113513814premi_ss
premium13310364premi_um
premiums1437534premiums
premix173710334premi__x
premixed20338014premixed
premixes193110084premixes
premolt11312074pre_molt
prepill1147584prepi_ll
preplant12712914preplant
preppiest1236984preppiest
preprint12314184preprint
prerinse1038634prerinse
presage10312294presag_e
presaged1238804presaged
presager1138444presager
presages11312204presages
prescient13411324prescient
present94022734pre_sent
preset84430984pre__set
preside10715614presi_de
presided12410554presided
president12410994president
presider11410424presider
presides11414914presides
presidia1147274presidia
presidio1146154presidio
presifts1366594presifts
presignal12105554presignal
presort95219544pre_sort
presplit1247754presplit
prest75736354pre___st
prestige11310734prestig_e
prestiges12310594prestiges
preterit10315854preterit
pretest9517634pre_test
pretext1639664pre_text
pretreat10311924pretreat
prettiest1199804prettiest
prevent124016554pre_vent
preview1536474previ_ew
previews1634514previews
previous1337824previous
previse123713794previ_se
prevised143611074prevised
previses133814284previses
previsits1446794previsits
previsor13116304previsor
prewash1535214prewash_
preweighed2042214preweighed
prewire124311144prewi_re
prewired14358474prewired
prewires133811014prewires
prexies163415004prexi_es
preying133114554preyi_ng
priciest122112904priciest
priest84125424pr__iest
prig75924874pr__ig__
prigs85219704pr__ig_s
print74837464pr__i_nt
privet113821344pr__ivet
priviest132310314priviest
prizefighter3061014prizefighter
probit103218354probi__t
prodigal1246004prodigal
prodigy1435574prodig_y
profile123211154profi_le
profiled14338524profiled
profiler13287644profiler
profiles133211234profiles
profited14279974profited
profiter132710204profiter
profits122911244profi_ts
profligate1654014profligate
prohibit1547194prohibit
prosiest10416524prosiest
prosit85124594prosi__t
protist9320224proti_st
prudish1376564prudish_
prurient1048234prurient
prurigo1043024prurig_o
prurigos1142364prurigos
puffiest1647324puffiest
pupfish1735534pupfish_
rebirth1244934_rebirth
rebought1474404_rebought
recit75235104_reci__t
redfish1437794_redfish_
redigest1039734_redigest
redipt94116744_redi_pt
reefiest112811484reefiest
refect114319334_ref_ect
refelt94521424_ref_elt
refighting1845204_refighting
refigure1254694_refigure
refile95122374_refi_le
refiled114318654_refiled
refiles104122424_refiles
refill94514054_refi_ll
refills103711424_refills
refilm114311404_refi_lm
refilms12347504_refilms
refind104717074_refi_nd
refinds114512124_refinds
refine95225694_refi_ne
refined114720004_refined
refiner105316914_refiner
refines105426344_refines
refire95419474_refi_re
refired115116994_refired
refires104820314_refires
refits94017654_refi_ts
refix155212484_refi__x
refixed183611154_refixed
refixes174813174_refixes
reflect123913714_reflect
reflet94024234_ref_let
refloat10310834_refloat
refract121311604_refract
refront10313264_refront
reft75141274_ref___t
refuge105312614_refug_e
refuged125410874_refuged
refugee115310944_refugee
refuges115413374_refuges
refugia1144314_refugia
regilt71217494_regi_lt
reign65015194_re_ig_n
reigns74811754_re_igns
rejig133810124_rejig__
rejigs14368094_rejig_s
reliant7319244_reliant
relict83623904_reli_ct
relighted1436864_relighted
relish93916954_relish_
relist64628414_reli_st
relit55340684_reli__t
remiges103015474_remiges
remint85329984_remi_nt
remit75737224_remi__t
remixt155014854_remi_xt
renig64518914_renig__
renigs74314594_renig_s
rerig64018484_rerig__
rerigs74014794_rerig_s
resift94017724_resi_ft
resighted1436524_resighted
resign74212584_resig_n
resigns83910964_resigns
resist64524534_resi_st
resit54241044_resi__t
resought1254994_resought
retaught1244664_retaught
retighten1374774_retighten
retint65633444_reti_nt
revisit10311374_revisit
reweigh1464774_reweigh_
reweighs1583204_reweighs
righto104111094_r__ighto
rights104019334_r__ights
righty135011834_r__ighty
safelight16124474safelight
sennight1245144sennight
serfish1348974serfish_
sidelight14175484sidelight
sight94629294___sight
skeigh14265904ske_igh_
skreigh15243704skre_igh_
skreighs16203154skre_ighs
skylight1943994skylight
sleigh10258204sle_igh_
sleighs11245674sle_ighs
sleights12275914sle_ights
slight103416004__slight
spaceflight2261374spaceflight
spotlight1543714spotlight
sprights14167144spr__ights
straight1249184straight
sunlight1245964sunlight
superlight1646034superlight
supertight1655894supertight
tight93626504___tight
tonight1138744_tonight
topflight1843544topflight
trefah1235094tref_ah_
twilight1543904twilight
twinight1543074twinight
unbright1444704unbright
unsight1137484_unsight
unweight1544744unweight
uplight13167364_uplight
uprights14145314upr__ights
uptight13176034_uptight
weeknight20112134weeknight
weigh125412514_we_igh_
weighs13338874_we_ighs
weights14409554_we_ights
weighty17376234_we_ighty
wight123725574___wight
wrights14318994wr__ights
wrought14276934wr_ought

Search took 16 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 Filter1786911616090.890200776.4
2DLD Change Limit16160947214.36011254.1
3Display Results4724720.1862537.6
 (SQL Overall)17869147215.43611576.3
 
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.