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

110 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
pronoun93902(None) 
pronouns1047181pronouns
phonon114012032phono_n
prenoon9310042prenoon
profound1444922profound
progun968782pro_gun
pronota939752pronota
pronotum1245142pronotum
pronounce1354662pronounce
propound1346392propound
proton84318892proto_n
adnoun757033_adnoun
arenous7314183arenous
arsonous846383arsonous
brownout1345683brownout
chronon1237353chrono_n
croon75522783cro_o_n
croton84415453croto_n
dromon939363dromo_n
dropout10410003dropout
fronton1037203fronton
glonoin875673glonoin
honour94710863_honour
ironbound1242693ironbound
ironman936613ironman
ironmen936453ironmen
kronen10348913kron_en
kronor10417233krono_r
kronur10415313kron_ur
kroon94514483kro_o_n
noun45724183___noun
ozonous1645253ozonous
pennon8310643penno_n
phono104917023phono__
phonons123310243phonons
phonos114114783phono_s
photon1111514823photo_n
pinon76024533p_ino_n
ponton83217643p_onton
pontoon93010703p_ontoon
poon67341263p_o_o_n
popgun1145733p_opgun
porno75120653porno__
pornos85015243porno_s
porous84419473p_orous
poyou102611513p_oyou_
poyous112911613p_oyous
prebound1345893prebound
precoup1336123precoup
prenomen1249633prenomen
preworn124711213preworn
printout1048123printout
prion75119993pr_io_n
prison8514023priso_n
prodrug1142953prodrug
profounds1543933profounds
prognose1146463prognose
prolan8414693pro_lan
prolog94212973prolo_g
prologs103512133prologs
prologue1146833prologue
prolong10319633prolong
promo95619993promo__
promoed12310083promoed
promoing13310463promoing
promos105116413promo_s
promote11313143promote
pronate9418873pronate
prone75332623pron__e
pronely12310243pronely
prong85218113pron__g
pronged113912393pronged
pronghorn1543543pronghorn
pronging123511843pronging
prongs94314483pron_gs
pronounced15243723pronounced
pronouncer1453923pronouncer
pronounces1454993pronounces
pronto8313993pron_to
proof105221533pro_o_f
proofs114511683pro_ofs
propman1339063propman
propmen1338763propmen
propone112716303propone
propose112714843propose
propounds1444963propounds
prorogue1145243prorogue
proso77222413proso__
prosody1336433prosody
prosoma11310223prosoma
prosos85718553proso_s
protean92412193protean
protein92414723protein
proteus92511593proteus
protium11312283protium
protons93118003protons
proud84615483pr__oud
prounion1046823prounion
proven114314773pro_ven
provoke1676123provoke
provost1238573provost
prunus8399363prun_us
renown9369983_renown
ronion63315643_ronion
ronyon9309133_ronyon
runout6414873_runout
trogon73611753trogo_n
uranous7310723uranous
urinous7310083urinous
vodoun1036233_vodoun

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.1561145455.1
2DLD Change Limit1340271106.87619492.0
3Display Results1101100.0303666.7
 (SQL Overall)1786911107.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.