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

164 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
prewarm1447961(None) 
prearm104512351pre_arm
prewar114712581prewar_
prewarms15406731prewarms
prewarn124410151prewarn
rewarm115913491_rewarm
prearms11369172pre_arms
preform1439612preform
prepare111913622prepare
preterm11310162preterm
prewarmed17104562prewarmed
prewarns13456942prewarns
prewash1535212prewash
prewire124311142prewire
prework164210912prework
preworn124711222preworn
prewrap14104972prewrap
prowar114110942prowar_
rearm75923572_re_arm
reward106017642_reward
rewarms12439602_rewarms
aswarm11107913_aswarm
beswarm1445783beswarm
beware11313713_beware
beworm1339993_beworm
bream95121813bre_a_m
brewage1347183brewage
brewer114812553brewer_
brewers123811063brewers
brewery15376963brewery
cream95721353cre_a_m
dewar95817733_dewar_
dewars105117073_dewars
deworm1249533_deworm
dream85120393dre_a_m
drear65016903dre_ar_
drears74614253dre_ars
dreary104611673dre_ary
firearm1237203fire_arm
fireworm1646693fireworm
forearm1238703fore_arm
forewarn14117173forewarn
freeware1446173freeware
froward1436673froward
leeward1135783leeward
lukewarm1742123lukewarm
overarm12239793overarm
overwarm16236933overwarm
pear69745233p_e_ar_
pearl75324463p_e_arl
pears75138613p_e_ars
peart76440753p_e_art
perform1439283perform
perm85834633p_e__rm
petard95013803p_etard
pinworm1467183pinworm
plenary1237543plenary
poleward1455943poleward
praam94815613pr__aam
pram85733493pr__a_m
preach133613923pre_ach
preact103220393pre_act
preamp1238993pre_amp
prearmed1397993pre_armed
prebade12310283prebade
prebake1539093prebake
preboard1338263preboard
preboom1348253preboom
precast11314853precast
precava1445093precava
precure11312553precure
predate10616893predate
predawn1335353predawn
predry1237873pre_dry
prefab1336243prefa_b
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preforms1537403preforms
pregame1239553pregame
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prela_w
prelim10311423pre_lim
premade12311443premade
preman104117453prema_n
premium13310363premium
prename11412643prename
preoral9312673preoral
prepack1757643prepack
prepaid12310133prepaid
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepave14228873prepave
prepay13310313prepa_y
prepays1437483prepays
prerace11414123prerace
presa74319043presa__
presage10312293presage
presale9416353presale
presort95219543presort
pretape113511623pretape
pretax152310193preta_x
preterms1237223preterms
pretor8315753pretor_
pretors9316813pretors
pretrim11310783pretrim
prevail1238243prevail
preverb14317063preverb
prewarming18145173prewarming
prewarned1594773prewarned
prewired14358473prewired
prewires133811013prewires
preworks17599013preworks
prewraps15114053prewraps
preyer114413733preyer_
preyers124412363preyers
primary1437703primary
procarp1346823procarp
program12311693program
prower114218123prower_
psywar1443323psywar_
psywars1533673psywars
realm75621623_re_alm
ream65841613_re_a_m
rear45644553_re_ar_
rearms85114653_re_arms
rears54739653_re_ars
rebar75420193_rebar_
rebars84019833_rebars
redware1139363_redware
reearn6612143_reearn
reform11312713_reform
regard85215773_regard
remark123512373_remark
repark123511713_repark
rereward1246143rereward
retard75018933_retard
rewake135218463_rewake
rewan85623663_rewa_n
rewards114813993_rewards
rewarmed14257433_rewarmed
rewash1237673_rewash
rewax155713923_rewa_x
rewear93012003_rewear_
rewears102911043_rewears
rewire95421413_rewire
reword106321413_reword
rewore938030163_rewore
rework136619793_rework
reworn98122203_reworn
rewrap11127533_rewrap
sewar85421103_sewar_
sewars94018633_sewars
steward1138063steward
swarm106218843__swarm
uprear8168793upre_ar_
uprears9107493upre_ars
warm95935673___warm
wireworm1645893wireworm

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.390458182.1
2DLD Change Limit1340271646.17021722.4
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.62326980.4
 
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.