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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
rearm7592357(None) 
prearm104512351prearm
realm75621621realm
ream65841611rea_m
rear45644551rear_
rearms85114651rearms
rears54739651rears
rewarm115913491rewarm
alarm76621422alarm
arm58449622__arm
barm86739602_barm
beam86939232bea_m
bear66844642bear_
beard86024962beard
bears75739042bears
berm86732752be_rm
bream95121812brea_m
charm126124662charm
cream95721352crea_m
dear55343602dear_
dears65736882dears
deary95826842deary
derm76031892de_rm
dream85120392drea_m
drear65016902drear_
drears74614252drears
dreary104611672dreary
ear36867882_ear_
earl45838142_earl
earn46737552_earn
ears46356592_ears
farm95934532_farm
fear75337792fear_
fears84829392fears
firearm1237202firearm
forearm1238702forearm
gear55934972gear_
gears64628692gears
germ75428962ge_rm
harm95637792_harm
hear76143882hear_
heard95222752heard
hears86737372hears
heart85440742heart
herm95636152he_rm
inarm7314422inarm
lear47045952lear_
learn55322662learn
lears55938732lears
leary85927382leary
near45236502near_
nears55529422nears
pear69745232pear_
pearl75324462pearl
pears75138612pears
peart76440752peart
perm85834632pe_rm
prearms11369172prearms
prewarm14479612prewarm
ram56867272r_a_m
rare45348432r_are
reach105123882reach
react74634332react
read55942532rea_d
readd74617132readd
reads64835272reads
ready94821502ready
real45750292rea_l
realms84913492realms
reals55038652reals
reams75729622reams
reap65934742rea_p
reaps75626192reaps
reared75930012reared
rearer64928912rearer
rearmed103912822rearmed
reata54225392reata
reave84528022reave
rebar75420192rebar_
rebars84019832rebars
redry94314362redry
reearn6612142reearn
reform11312712reform
refry114412462refry
regard85215772regard
rehem103815352rehem
rem56150042re__m
remark123512372remark
repark123511712repark
repro75315912repro
reran57329102reran
retard75018932retard
retem74221952retem
retrim83514882retrim
retro55020952retro
retry84718082retry
reward106017642reward
rewarms12439602rewarms
roam67132412roa_m
roar46328572roar_
roars55622242roars
seam66645972sea_m
sear47353842sear_
sears54744912sears
smarm95517602smarm
swarm106218842swarm
team66238652tea_m
tear45242882tear_
tears55436462tears
teary85124052teary
term66233152te_rm
tharm105916642tharm
unarm7314452unarm
warm95935672_warm
wear75836722wear_
wears86030302wears
weary115620612weary
year76534252year_
yearn86316432yearn
years84527672years

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001201.70331591.3
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.04687336.8
 
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.