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

151 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
prenoon931004(None) 
forenoon1146822forenoon
pennon8310642p_ennon
prebook1557522prebook
preboom1348252preboom
precook1577802precook
precool1139012precool
prenomen1249632prenomen
prenotion1149172prenotion
preunion1046892preunion
preworn124711222preworn
pronoun939032pronoun
renown9369982_renown
alencon945733alencon
arenose7311373arenose
arenous7314183arenous
bradoon1037353bradoon
bridoon1046203bridoon
crepon1039943cre_pon
croon75522783cr__oon
dragoon935283dragoon
erenow937373eren_ow
forenoons1245743forenoons
fronton1037203fronton
grunion835433grunion
guenon736403guen_on
kroon94514483kr__oon
midnoon1044683midnoon
noon47134623___noon
paeon74819493pae__on
parergon1144393parergon
patroon92811973patroon
pelon74423213p_e_lon
peloton938743p_eloton
pengo84317593p_engo_
pengos94612413p_engos
penman10312323p_enman
penmen10311493p_enmen
pennons939713p_ennons
pension9412203p_ension
peon65635243p_e__on
pereion9312053pereion
pereon83517453p_ereon
perigon1039853perigon
pernio8513143pernio_
pernod9310453pern_od
pernods1038483pernods
perron83216623p_erron
person83517873p_erson
phenol1149253phen_ol
phenols1238103phenols
phenom1339473phen_om
phenoms1437813phenoms
phenoxy2243483phenoxy
phonon114012033phon_on
pinion83815893p_inion
pinon76024533p_in_on
pinyon11459763p_inyon
platoon938953platoon
pleon74216383ple__on
pleuron976343pleuron
ponton83217643p_onton
pontoon93010703pontoon
poon67341263p___oon
praenomen1345013praenomen
preboil1148953preboil
prebooks1656303prebooks
prebound1345893prebound
precode12311853precode
precooks1656763precooks
precools1237703precools
precoup1336123precoup
predawn1335353predawn
preen75925053pre__en
preform1439613preform
preload1049813preload
preman104117453pre_man
premen105017803pre_men
premold1247863premold
premolt11312073premolt
prename11412643prename
prenomens1347073prenomens
prenomina1347883prenomina
prenotions1248293prenotions
preop94715873pre__op
preops104911943pre_ops
preplan1149953preplan
preriot9316413preriot
prerock1536723prerock
preshow15237413preshow
preshown16255633preshown
presoak1348453presoak
presold1059603presold
presong1039843presong
presort95219543presort
pressor93512883pressor
presto84216203presto_
prestos93716083prestos
preteen939873preteen
pretold1049083pretold
pretor8315753pre_tor
pretors9316813pretors
preunions1146483preunions
prewarn124410153prewarn
prework164210913prework
princox1843573princox
prion75119993pr__ion
prison8514023pr_ison
pronota939763pronota
pronouns1047203pronouns
pronto8313993pronto_
proof105221533pr__oof
proton84318893pr_oton
prounion1046823prounion
puccoon1343503puccoon
pyrenoid1446873pyrenoid
racoon83814473_racoon
ratoon64417373_ratoon
reason62616333_reason
rebook125213203_rebook
reboot84119333_reboot
reborn810016963_reborn
reckon123010543_reckon
recoin84320293_recoin
recon75624243_re_con
recook125513923_recook
redon65424883_re_don
region74614903_region
rejoin134012243_rejoin
reloan6415693_reloan
relook104813743_relook
renin54830033_ren_in
rennin63914033_rennin
renowns10277833_renowns
renvoi945863_renvoi
reroof9315003_reroof
resown94112923_resown
retook104313443_retook
retool63914483_retool
retorn610923433_retorn
reunion737673_reunion
rewon86920583_re_won
reworn98122203_reworn
ronion63315643_ronion
ronyon9309133_ronyon
sphenodon1552563sphenodon
tendon7312033_tendon
tenon53320513_ten_on
ternion739493ternion
treason748763treason
xenon122612453_xen_on

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 Limit1340271515.95322514.2
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.40527898.7
 
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.