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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
producer135584(None) 
produce1267511produce_
produced1456071produced
producers1454881producers
produces1347901produces
coproducer1763072coproducer
procurer1235832procurer
prodder1147952prod_der
product1279232produc_t
products1376512products
prouder10310382pro_uder
reducer1059002_reducer
reproducer1544072reproducer
traducer1144582traducer
adducer1184163_adducer
arouser74514423aro_user
conducer13127373conducer
coproduce1643543coproduce_
coproduced1852943coproduced
coproducers1862533coproducers
coproduces1763723coproduces
grocer94212143gro__cer
grodier939673grod_ier
grouper104210093gro_uper
grouser84513693gro_user
grouter84412523gro_uter
inducer10318763_inducer
introducer13144093introducer
plodder1146003plod_der
podgier11338723p_odgier
policer113112683p_olicer
pouncer113511233p_ouncer
pourer84516043p_o_urer
pouter83923983p_o_uter
prancer113613383pr_ancer
prefacer1537983prefacer
preluder1135733preluder
prepuce1337833prepuce_
prepuces1438583prepuces
presumer1247583presumer
pricer103918293pr__icer
prober104516073pro__ber
procure1138573procure_
procured1336603procured
procurers1345033procurers
procures1239213procures
prodded1257733prod_ded
prodders1237463prod_ders
producing1556143producing
profaner13197943profaner
proffer15126933pro_ffer
profiler13287643profiler
profiter132710203profiter
profuse1237153profuse_
progger11319373pro_gger
promiser122510673promiser
promoter12311453promoter
prompter1437983prompter
pronouncer1453923pronouncer
pronuclear1452353pronuclear
pronuclei1343263pronuclei
proofer12149103pro_ofer
proper104319953pro__per
properer1259203properer
proposer121810633proposer
proser84223463pro__ser
prosier93817483pro_sier
prosper114012193pro_sper
protecter13179103protecter
prover113819723pro__ver
provider1436703provider
provoker1784913provoker
prower114218123pro__wer
prowler123310013pro_wler
pruner83413453pr__uner
reduce9713253_reduce_
reduced11610323_reduced
reducers1147263_reducers
reduces10513343_reduces
reproduce1444793reproduce_
reproduced1644313reproduced
reproducers1653323reproducers
reproduces1544933reproduces
rouser65224083_ro_user
router65025843_ro_uter
seducer1056503_seducer
sprucer11317683spr__ucer
traduce1036353traduce_
traduced1244673traduced
traducers1243723traducers
traduces1136563traduces
trouncer1035443trouncer
trouper93811433tro_uper
trouser73812473tro_user
unproduced1643273unproduced

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 Filter1786911461620.423422437.4
2DLD Change Limit146162956.93621073.0
3Display Results95950.0501900.0
 (SQL Overall)178691957.40924118.1
 
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.