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

136 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
prewarns1345694(None) 
prewarms15406731prewarms
prewarn124410151prewarn_
forewarns1585632forewarns
prearms11369172pre_arms
predawns1444362predawns
prepares122014162prepares
prewar114712582prewar__
prewarm14479612prewar_m
prewarned1594772prewarned
prewires133811012prewires
preworks17599012preworks
preworn124711222preworn_
prewraps15114052prewraps
reearns749102_reearns
rewards114813992_rewards
rewarms12439602_rewarms
bewares12313373_bewares
brewages1436383brewages
brewers123811063brewer_s
cremains1238693cremains
deewans11306903deewa_ns
dewans105215143_dewa_ns
dewars105117073_dewar_s
drears74614253dre_ar_s
earns55927563__e_arns
forewarn14117173forewarn_
freewares1545943freewares
learns65513743_le_arns
leewards1244983leewards
paeans85118263pae_a_ns
paesans93312693paesa_ns
peans75437643p_e_a_ns
pearls84715393p_e_arls
pears75138613p_e_ar_s
pecans101515833p_eca_ns
pekans121710553p_eka_ns
pertains102113423pertains
petards104311153p_etards
prawns11509023pr__awns
preacts113211363pre_acts
preamps1336613pre_amps
prearm104512353pre_ar_m
prebakes1639013prebakes
preboards1446423preboards
precasts1239453precasts
precures12312903precures
predates11615813predates
predawn1335353predawn_
preens85020113pre__ens
prefabs1435163prefa_bs
prefaces15311063prefaces
prefades1439533prefades
prefers123713333prefer_s
prefires134313283prefires
preforms1537403preforms
prefrank1764233prefrank
prefranks1862993prefranks
pregames1339003pregames
prehardens1673443prehardens
prelates10418573prelates
preman104117453prema_n_
prenames12311643prenames
prepacks1836583prepacks
prepare111913623prepar_e
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
preparing14311643preparing
prepaves15189193prepaves
prepays1437483prepa_ys
preplans1249613preplans
presages11312203presages
presales10315263presales
presorts105311683presorts
pressruns1144293pressruns
pretapes122811533pretapes
preteens1038123preteens
preterms1237223preterms
pretors9316813pretor_s
pretrains11410143pretrains
prevails1337663prevails
preverbs15295303preverbs
prewarmed17104563prewarmed
prewarming18145173prewarming
prewarning16135193prewarning
prewash1535213prewa_sh
prewashes1744753prewashes
prewire124311143prewir_e
prewired14358473prewired
prewiring1547893prewiring
prework164210913prewor_k
prewrap14104973prew_rap
preyers124412363preyer_s
procarps1445973procarps
prolans9314273prola_ns
prowar114110943prowar__
psywars1533673psywar_s
rearms85114653_re_arms
rears54739653_re_ar_s
rebars84019833_rebar_s
redans75421023_reda_ns
redwares1239053_redwares
reearn6612143_reearn_
regains84316583_regains
regards94112563_regards
relearns836303_relearns
remains94117913_remains
remans84823003_rema_ns
remarks13329983_remarks
reparks13249513_reparks
rerewards1344643rerewards
retains74522253_retains
retards85015003_retards
returns79712593_returns
rewakens15406243_rewakens
rewakes144614983_rewakes
rewan85623663_rewa_n_
reward106017643_rewar_d
rewarm115913493_rewar_m
rewaxes173911333_rewaxes
rewears102911043_rewear_s
rewins95020823_rew_ins
rewires104717113_rewires
rewords115413983_rewords
reworks145113603_reworks
reworn98122203_reworn_
rewraps12136563_rewraps
rowans95715343_rowa_ns
sewans95215903_sewa_ns
sewars94018633_sewar_s
stewards1236383stewards
trepans92311593trepa_ns
uprears9107493upre_ar_s
warns87231003___warns
yearns9509543_ye_arns

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.436409841.7
2DLD Change Limit1461621366.81321453.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.31224438.0
 
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.