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

198 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
neap6692701(None) 
heap96432891heap
leap66032681leap
nap56753201n_ap
neaps75618321neaps
near45236501near
neat46356781neat
neep65728311neep
reap65934741reap
sneap75514821sneap
anear55420322anear
atap66722452atap
bap76455842_bap
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
becap114315052becap
beep85931212beep
cap76758982_cap
cep75736332ce_p
chap114928492chap
cheap126915942cheap
clap86429042clap
crap85731842crap
dap66652452_dap
dead65434242dead
deaf85838402deaf
deal56347412deal
dean56039482dean
dear55343602dear
deep76031882deep
ear36867882_ear
eat36989052_eat
eau37450942_eau
feal713940422feal
fear75337792fear
feat76458222feat
flap96128702flap
frap95925812frap
gap67055612_gap
gear55934972gear
hap87360052_hap
head87137172head
heal75645692heal
heaps105223222heaps
heapy135914982heapy
hear76143882hear
heat77061422heat
help95328922help
hemp115725622hemp
hep86644142he_p
jean116629282jean
jeep135624842jeep
kea76540912kea_
keas86337092keas
keep106329812keep
kelp105322802kelp
kemp126418762kemp
kep96437202ke_p
knap105815402knap
knead10429662knead
lap58565272_lap
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leaps75522932leaps
leapt75027472leapt
lear47045952lear
leas45954182leas
map77255112_map
mead75531602mead
meal65643172meal
mean65538082mean
meat66359602meat
na28652482n_a_
naan47621932naan
nab56954922n_ab
nae35952742n_ae
nag46450812n_ag
nah69847002n_ah
nam55953392n_am
nan37854872n_an
napa66927262n_apa
nape65230802n_ape
naps66238582n_aps
naw66346492n_aw
nay66952772n_ay
ne27045102ne__
nears55529422nears
neath86020282neath
neats55931902neats
neb57238622ne_b
nebs66124982nebs
neck105423662neck
nee36657782ne_e
need54934152need
neem67328082neem
neeps75617882neeps
neg47237342ne_g
negs55727362negs
neif75429482neif
nema65522522nema
nemas75321572nemas
nene45932062nene
neon47026422neon
nerd56624942nerd
ness45526562ness
nest45548732nest
net36670292ne_t
netop7312342netop
nets45941532nets
nett46643232nett
neuk87416602neuk
neum66723082neum
neve76224832neve
nevi75116422nevi
new66237092ne_w
news76127372news
newt76933742newt
next116631082next
nip56945982n_ip
nipa69421632nipa
pap76758402_pap
pea56657242pea_
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
pear69745232pear
peas65755062peas
peat65967932peat
peep85833692peep
pep76447082pe_p
perp89029892perp
rap56261962_rap
read55942532read
real45750292real
ream65841612ream
reaps75626192reaps
rear45644552rear
recap95718022recap
remap95418102remap
rep55847802re_p
repp85418742repp
sap56463232_sap
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
seep66540342seep
slap66434042slap
snap65727032snap
sneak96016172sneak
sneaps84510862sneaps
soap65831132soap
swap95925432swap
tap57663872_tap
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
temp85323332temp
tepa66021682tepa
trap67532802trap
uncap9312282uncap
veal76936812veal
veep95325092veep
wap86553372_wap
weak117126302weak
weal75838682weal
wean75734352wean
wear75836722wear
weep95131652weep
whap125119642whap
wrap96821972wrap
yap85949822_yap
yea66445752yea_
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yelp95621352yelp
yep86638962ye_p
zap145840692_zap
zeal135530332zeal
zep147129142ze_p

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 Filter178691298720.1401276364.3
2DLD Change Limit298721981.26623595.6
3Display Results1981980.0762605.3
 (SQL Overall)1786911981.482120574.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.