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

161 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
peart7644075(None) 
heart85440741heart
part65967461p_art
pear69745231pear_
pearl75324461pearl
pears75138611pears
peat65967931pea_t
pert66759321pe_rt
apart74330672apart
art38679142__art
bear66844642bear_
beard86024962beard
bears75739042bears
beast76338642beast
beat66168302bea_t
beaut75135212beaut
boart78835932boart
cart66570342_cart
chart105038282chart
dart55857872_dart
dealt65234282dealt
dear55343602dear_
dears65736882dears
dearth104212512dearth
deary95826842deary
depart94720562depart
derat65044082derat
ear36867882_ear_
earl45838142_earl
earn46737552_earn
ears46356592_ears
earth85023052_earth
east46659102_east
eat36989052_ea_t
epact94921532epact
fart76860562_fart
fear75337792fear_
fears84829392fears
feast85932722feast
feat76458222fea_t
gear55934972gear_
gears64628692gears
hart76865772_hart
hear76143882hear_
heard95222752heard
hears86737372hears
hearth125315212hearth
hearts96218942hearts
hearty126313632hearty
heat77061422hea_t
kart86750802_kart
leant56737782leant
leapt75027472leapt
lear47045952lear_
learn55322662learn
learnt64019252learnt
lears55938732lears
leary85927382leary
least56134882least
lyart85121882lyart
mart66865972_mart
meant76537202meant
meat66359602mea_t
near45236502near_
nears55529422nears
neat46356782nea_t
pact86648722p_act
pant66061252p_ant
par57467022p_ar_
para65242172p_ara
pard76441322p_ard
pare66760842p_are
park105237492p_ark
parr65731152p_arr
pars67560792p_ars
parts77743372p_arts
party106630612p_arty
past65959012p_ast
pat58089462p_a_t
pea56657242pea__
peace95026082peace
peach125422492peach
peag75431342pea_g
peage84723562peage
peags86122842peags
peak106535202pea_k
peaks114825622peaks
peaky145718152peaky
peal68648102pea_l
peals75235492peals
pean66147172pea_n
peans75437642peans
peanut8318182peanut
pearls84715382pearls
pearly116414842pearly
pearter9412742pearter
peartly1267452peartly
peas65755062pea_s
pease75231112pease
peats76140192peats
peaty105725692peaty
peavy135014842peavy
pedant9319492pedant
pedro8313152pedro
peer66238352peer_
peers75130272peers
peery105719442peery
pelt67651082pe_lt
pent66559072pe_nt
per56353092pe_r_
pere66450262pe_re
peri65636972pe_ri
perk106232842pe_rk
perm85834632pe_rm
perp89029892pe_rp
perry105222712perry
perv97224812pe_rv
pest65555292pe_st
pet56477302pe__t
petard95013802petard
petit74332652petit
pewit104622792pewit
phat95837862pha_t
plait75631572plait
plant75437112plant
plat66048872pla_t
pleat74734472plea_t
port66059632p_ort
prat65952042pra_t
preact103220392preact
prearm104512342prearm
quart144027852quart
react74634332react
rear45644552rear_
rearm75923562rearm
rears54739652rears
scart76139772scart
sear47353842sear_
sears54744912sears
seat47575562sea_t
smart75834092smart
spear75821062spear_
spears84019472spears
start55642312start
swart86234642swart
tart47566182_tart
tear45242882tear_
tears55436462tears
teary85124052teary
teat45963632tea_t
updart9310742updart
vert77249372ve_rt
wart77866082_wart
wear75836722wear_
wears86030302wears
weary115620612weary
wert79749822we_rt
year76534252year_
yearn86316432yearn
years84527672years
yeast85327942yeast

Search took 2 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.0931921408.6
2DLD Change Limit538001611.68631909.8
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.82597912.9
 
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.