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

179 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
preworn12471122(None) 
prewarn124410151prewarn
prework164210911prework
reworn98122201_reworn
careworn1347882careworn
foreworn14108862foreworn
preform1439612preform
prenoon9310042prenoon
presort95219542presort
pretor8315752pretor_
pretors9316812pretors
prewar114712582prewar_
prewarm14479612prewarm
prewarns13456942prewarns
prewire124311142prewire
preworks17599012preworks
reborn810016962_reborn
retorn610923432_retorn
rewon86920582_rewo_n
reword106321412_reword
rewore938030162_rewore
rework136619792_rework
artwork1447093artwork
beworm1339993_beworm
brewer114812553brewer_
brewers123811063brewers
brewery15376963brewery
crepon1039943crepo_n
crewman1435753crewman
crewmen1436383crewmen
dehorn10439653_dehorn
deworm1249533_deworm
firework1847413firework
fireworm1646693fireworm
foresworn15126073foresworn
forewarn14117173forewarn
foreword15118963foreword
forsworn14125763forsworn
forworn13107793forworn
freeborn1344803freeborn
fretwork1845693fretwork
newborn1244283_newborn
outworn101610753outworn
overworn14118833overworn
paeon74819493pae_o_n
pelon74423213p_elo_n
peon65635243p_e_o_n
pereion9312053pereio_n
pereon83517453pereo_n
perform1439283perform
perron83216623perro_n
person83517873perso_n
piefort1249533piefort
pilewort1389133pilewort
pinwork16107243pinwork
pinworm1467183pinworm
pleon74216383ple_o_n
pleuron976343pleuron
plexor1535253plexor_
plexors1645423plexors
popcorn1344903popcorn
porn65636023p___orn
praetor938973praetor_
praetors1039833praetors
prawn105312433praw__n
prearm104512353pre_arm
preboard1338263preboard
preboil1148953preboil
prebook1557523prebook
preboom1348253preboom
prebound1345893prebound
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precure11312553precure
predawn1335353predawn
predry1237873pre_dry
preen75925053pre__en
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preforms1537403preforms
preload1049813preload
preman104117453pre_man
premen105017803pre_men
premodern1444423premodern
premold1247863premold
premolt11312073premolt
premoral1249713premoral
premorse1237553premorse
prenomen1249633prenomen
preop94715873pre_o_p
preops104911943pre_ops
preoral9312673pre_oral
prepare111913623prepare
preplan1149953preplan
prerock1536723prerock
prescore124812373prescore
preshown16255633preshown
presoak1348453presoak
presold1059603presold
presong1039843presong
presorts105311683presorts
pressor93512883pressor_
pressors103212693pressors
pressrun1045033pressrun
presswork1854533presswork
prestore104217353prestore
preteen939873preteen
preterm11310163preterm
pretold1049083pretold
pretorian11511553pretorian
preverb14317063preverb
prewarms15406733prewarms
prewarned1594773prewarned
prewash1535213prewash
prewired14358473prewired
prewires133811013prewires
prewiring1547893prewiring
preworked1954653preworked
preworking2044233preworking
prewrap14104973prewrap
preyer114413733preyer_
preyers124412363preyers
prion75119993pr_io_n
prior74316173pr_ior_
priors83914483pr_iors
priory114110263pr_iory
prison8514023priso_n
pronoun939033pronoun
proton84318893proto_n
prowar114110943prowar_
prower114218123prower_
readorn8310483_readorn
rebore86625653_rebore
recoin84320293_recoin
recon75624243_reco_n
record96117433_record
recork126315493_recork
redon65424883_redo_n
reearn6612143_reearn
reform11312713_reform
rejoin134012243_rejoin
reloan6415693_reloan
remora8414593_remora
renown9369983_renown
report85326023_report
resorb84914353_resorb
resort65728623_resort
resown94112923_resown
retore67630773_retore
retort66831153_retort
return623222523_return
rewan85623663_rew_an
reward106017643_reward
rewarm115913493_rewarm
rewin85623963_rew_in
rewire95421413_rewire
rewoke1339521223_rewoke
rewoken145112293_rewoken
rewords115413983_rewords
reworks145113603_reworks
rewound1156433_rewound
rewove126420083_rewove
rewoven13557933_rewoven
sworn86115313__sworn
timeworn1344233timeworn
tremor84210403tremor_
tremors93711233tremors
tricorn937963tricorn
trueborn1043063trueborn
unsworn1046843unsworn
unworn93411333_unworn
warworn1357353warworn
wayworn1675293wayworn
wirework1846573wirework
wireworm1645893wireworm
worn75631753___worn

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 Limit1340271797.26318453.4
3Display Results1791790.0802237.5
 (SQL Overall)1786911797.74923059.9
 
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.