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

219 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
preed8512811(None) 
breed85526691breed
creed85727391creed
dreed75222841dreed
freed95223541freed
greed75125691greed
peed76239181p_eed
pree67044731pree_
preen75925051preen
prees75937171prees
premed114617751premed
preyed125313191preyed
pried84426861pried
pureed95017801pureed
reed55549621_reed
treed65626731treed
agreed84712502agreed
arced88224162arced
armed86324432armed
bleed85019802bleed
bread85523112bread
bred75130972br_ed
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
cered85227442cered
cred76530882cr_ed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115702creped
crewed125316552crewed
cried84624282cried
deed65340902_deed
dread74419022dread
dree56638322dree_
drees65628522drees
dried75321382dried
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
geed65435502_geed
gleed75320572gleed
gree56641562gree_
greeds84314282greeds
greedy11518842greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
heed86437602_heed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012062jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
paced106931682paced
paged95926782paged
paled85538722paled
paned85437182paned
pared86946762pared
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pated85237842pated
paved115525262paved
paveed12438892paveed
pawed115725612pawed
payed115925932payed
ped66751522p__ed
pee56066512p_ee_
peek106031432p_eek
peeked134314572peeked
peel65535612p_eel
peeled94119702peeled
peen65938082p_een
peened94318152peened
peep85833692p_eep
peeped113915382peeped
peer66238352p_eer
peered93819482peered
pees65257372p_ees
peeved124112882peeved
pend75934532p_end
pere66450262pere_
perea75026442perea
peres76246642peres
perked134617682perked
permed115217342permed
pieced113912102pieced
pied75035362p_ied
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
plead85818462plead
pled75231432p_led
plied85118592plied
poked125425392poked
poled84934842poled
pooed85226242pooed
pored85234512pored
porked134717622porked
ported94223242ported
posed85828412posed
poxed154817862poxed
prated94924922prated
prayed124815432prayed
preaged11612332preaged
prebend12319442prebend
prebid113512842prebid
precede1239632precede
preedit10512452preedit
preened103214982preened
preens85020112preens
prefer113813202prefer
premeds12389582premeds
premen105017802premen
preop94715872preop
prep86427672pr_ep
prepped11329892prepped
preps96220692preps
presa74319042presa
prese75228382prese
preset84430982preset
press75425952press
pressed103317302pressed
prest75736352prest
pretend104011012pretend
prevued1337142prevued
prex135722972pr_ex
prexes154915942prexes
prexy174611572prexy
prey96228482pr_ey
preyer114413732preyer
preys105717782preys
prez156126312pr_ez
prezes173614692prezes
priced115018882priced
pride84724732pride
prided103618032prided
prier75027762prier
pries74339532pries
primed115118912primed
prised94322202prised
prized184415392prized
probed114114822probed
proceed12310542proceed
prod76129502pr_od
proem94818272proem
prosed94921092prosed
proud84615482proud
proved125016032proved
prude84615972prude
pruned93413112pruned
pryer104415312pryer
pseud867042pseud
puked124716222puked
puled84926522puled
puree74632842puree_
purees84721682purees
purged104918262purged
purled94520742purled
purred94218072purred
pursed95220882pursed
read55942532_read
red46755802_r_ed
redd66323172_redd
rede55037662_rede
reded74829112_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020282_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
screed95718922screed
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
spread9312532spread
spree74830862spree_
sprees85620642sprees
steed66024942steed
teed55439262_teed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tweed94915092tweed
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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.0931921408.6
2DLD Change Limit538002191.92327977.1
3Display Results2192190.0464760.9
 (SQL Overall)1786912192.06286659.1
 
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.