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

181 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
prewarn12441014(None) 
prewar114712571prewar_
prewarm14479601prewarm
prewarns13456941prewarns
preworn124711211preworn
forewarn14117162forewarn
prearm104512342pre_arm
predawn1335352predawn
preman104117452prema_n
prepare111913622prepare
prewarms15406722prewarms
prewarned1594772prewarned
prewash1535212prewash
prewire124311132prewire
prework164210902prework
prewrap14104972prewrap
prowar114110942prowar_
reearn6612142_reearn
rewan85623662_rewa_n
reward106017632_reward
rewarm115913482_rewarm
reworn98122192_reworn
beware11313713_beware
brewage1347183brewage
brewer114812543brewer_
brewers123811053brewers
brewery15376953brewery
careworn1347873careworn
cedarn9408443_cedarn
crewman1435743crewman
crewmen1436373crewmen
deewan10267553deewa_n
dewan95718043_dewa_n
dewar95817733_dewar_
dewars105117073_dewars
drear65016903dre_ar_
drears74614253dre_ars
dreary104611673dre_ary
earn46737553__e_arn
forewarns1585633forewarns
foreworn14108853foreworn
freeware1446163freeware
froward1436673froward
learn55322663_le_arn
leeward1135783leeward
paean77222723pae_a_n
paesan85114093paesa_n
pean66147173p_e_a_n
pear69745233p_e_ar_
pearl75324463p_e_arl
pears75138613p_e_ars
peart76440753p_e_art
pecan91919033p_eca_n
pekan111613973p_eka_n
pertain92714963pertain
petard95013803p_etard
plenary1237543plenary
poleward1455943poleward
prawn105312433pr__awn
preach133613923pre_ach
preact103220393pre_act
preamp1238993pre_amp
prearms11369173pre_arms
prebade12310283prebade
prebake1539093prebake
preboard1338263preboard
precast11314853precast
precava1445093precava
precure11312553precure
predate10616893predate
predawns1444363predawns
predry1237863pre_dry
preen75925053pre__en
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preform1439603preform
prefrank1764233prefrank
pregame1239553pregame
preharden15104823preharden
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prela_w
premade12311443premade
premen105017803pre_men
prename11412643prename
prenoon9310043prenoon
preoral9312673preoral
prepack1757643prepack
prepaid12310133prepaid
prepared132210863prepared
preparer12169643preparer
prepares122014163prepares
preparing14311643preparing
prepave14228873prepave
prepay13310313prepa_y
prepays1437483prepays
preplan1149953preplan
prerace11414123prerace
presa74319043presa__
presage10312293presage
presale9416353presale
presort95219533presort
pressrun1045033pressrun
pretape113511623pretape
pretax152310193preta_x
preteen939873preteen
preterm11310153preterm
pretor8315743pretor_
pretors9316803pretors
pretrain10310923pretrain
prevail1238243prevail
preverb14317063preverb
prewarmed17104563prewarmed
prewarming18145173prewarming
prewarning16135193prewarning
prewired14358473prewired
prewires133811013prewires
prewiring1547893prewiring
preworks17599003preworks
prewraps15114053prewraps
preyer114413733preyer_
preyers124412363preyers
primary1437703primary
procarp1346823procarp
prolan8414693prola_n
prower114218123prower_
psywar1443323psywar_
psywars1533673psywars
rear45644553_re_ar_
rearm75923563_re_arm
rears54739653_re_ars
rebar75420193_rebar_
rebars84019823_rebars
reborn810016953_reborn
redan66125013_reda_n
redware1139353_redware
reearns749103_reearns
regain74517763_regain
regard85215773_regard
relearn747973_relearn
remain85919863_remain
reman75730153_rema_n
remark123512373_remark
repark123511713_repark
reran57329103_rera_n
rereward1246133rereward
resawn9399953_resawn
retain64523283_retain
retard75018933_retard
retorn610923423_retorn
return623222523_return
rewake135218463_rewake
rewaken144410273_rewaken
rewards114813993_rewards
rewarms12439593_rewarms
rewash1237673_rewash
rewax155713923_rewa_x
rewear93011993_rewear_
rewears102911033_rewears
rewin85623963_rew_in
rewire95421403_rewire
rewon86920573_rew_on
reword106321403_reword
rewore938030153_rewore
rework136619783_rework
rewrap11127533_rewrap
rowan85418733_rowa_n
sewan85921293_sewa_n
sewar85421093_sewar_
sewars94018623_sewars
steward1138053steward
trepan82511673trepa_n
uprear8168793upre_ar_
uprears9107493upre_ars
warn75239323___warn
yearn86316433_ye_arn

Search took 10 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 Limit1340271818.95314970.1
3Display Results1811810.0632873.0
 (SQL Overall)1786911819.17219482.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.